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/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
Creates a report of the current server status for diagnostic purposes. Configuration Options diagnostics() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 26.4.2.1, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
For example, to examine the definitions of the session view and format_bytes() function, use these statements: mysql> SHOW CREATE VIEW sys.session; mysql> SHOW CREATE FUNCTION sys.format_bytes; However, those statements display the definitions in ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. If you need a MyISAM table that is larger than the default limit and your operating system supports large files, the CREATE TABLE ... The ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
Note Named time zones can be used only if the time zone information tables in the mysql database have been created and populated. The MySQL installation procedure creates the time zone tables, but does not load them. For example: mysql_tzinfo_to_sql ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
To install functions from the library file, use the CREATE FUNCTION statement. The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. MySQL Enterprise Encryption functions are ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
For additional information about column indexes, see Section 13.1.14, “CREATE INDEX Statement”. Index Prefixes FULLTEXT Indexes Spatial Indexes Indexes in the MEMORY Storage Engine Index Prefixes With col_name(N) syntax in an index specification ... The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
You can also configure automatic statistics recalculation for individual tables by specifying the STATS_AUTO_RECALC clause when creating or altering a table. To override these system-wide settings and configure optimizer statistics parameters for ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...