PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-example.html
* * You can use mysql_library_init(0, NULL, NULL), and it * initializes the server using groups = { * "server", "embedded", NULL * }. These two example programs should work without any changes on a Linux or FreeBSD system. For other operating ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
GROUP_NAME If this server is a member of a group, shows the name of the group the server belongs to. This table shows the current status of the replication I/O thread that handles the replica's connection to the source. It contains values that ...
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
Also, any program that uses libmysqlclient and reads option files can enable the plugin by including an enable-cleartext-plugin option in an option group read by the client library. A client-side authentication plugin is available that enables ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
In other words, to be able to use an index, a prefix of the index must be used in every AND group. Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-metrics-table.html
You can also perform these actions for a group of counters using their common module name. The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables ...
https://dev.mysql.com/doc/refman/5.7/en/operator-precedence.html
Operator precedences are shown in the following list, from highest precedence to the lowest. Operators that are shown together on a line have the same precedence. When used as a comparison operator, it has the same precedence as <=>, >=, >, <=, <, ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
The GROUP BY and ORDER BY clauses can generate temporary tables, and these temporary tables can use the MEMORY storage engine if the original table does not contain any BLOB columns. For character and string columns, follow these guidelines: Use ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-file-summary-tables.html
Each file I/O summary table has one or more grouping columns to indicate how the table aggregates events. The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. Example file I/O event summary ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
A table can have no more than 255 unique element list definitions among its ENUM and SET columns considered as a group. A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values ...