PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
For string-quoting and identifier-quoting guidelines, see Section 9.1.1, “String Literals”, and Section 9.2, “Schema Object Names”. MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
The collation ID that you choose appears in these contexts: The ID column of the Information Schema COLLATIONS table. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for ...
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
You can verify that the UNDO files were created and obtain information about them by querying the Information Schema FILES table. ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
To verify that the table options were changed as intended, use SHOW CREATE TABLE, or query the Information Schema TABLES table. ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD ...
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
You can verify that the data files were created and obtain information about them by querying the Information Schema FILES table. ALTER TABLESPACE tablespace_name {ADD | DROP} DATAFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
To check the stored key distribution cardinality, use the SHOW INDEX statement or the INFORMATION_SCHEMA STATISTICS table. See Section 13.7.5.22, “SHOW INDEX Statement”, and Section 24.3.24, “The INFORMATION_SCHEMA STATISTICS Table”. Other ...ANALYZE TABLE performs a key distribution analysis and stores the distribution for the named table or ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
For information about using JSON data in MySQL, see Section 11.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ... This section ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/charset-database.html
The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET charset_name] [[DEFAULT] COLLATE collation_name] ALTER DATABASE db_name ... Every database has a database character set and a database ...