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/performance-schema-table-characteristics.html
The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-size-pl.html
(Many Linux and other operating system distributions provide their own packages for this library.) A MySQL user account having the necessary privileges. If you do not wish to use an existing account, then creating one using GRANT USAGE ON ... This ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-column-privileges-table.html
The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. The value can be any ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schema-privileges-table.html
The SCHEMA_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. The value can be any ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. The value can be any ...
https://dev.mysql.com/doc/refman/5.7/en/full-text-adding-collation.html
This section describes how to add a user-defined collation for full-text searches using the built-in full-text parser. The permitted range of IDs for user-defined collations is given in Section 10.14.2, “Choosing a Collation ID”. The sample ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the ...The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. Otherwise, users would not be able to name columns and tables using their own languages. The metadata requirements mean that the ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Input Preprocessing Each instance of col_name_or_user_var in LOAD DATA syntax is either a column name or a user variable. With user variables, the SET clause enables you to perform preprocessing transformations on their values before assigning the ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
A “login path” is an option group that permits only certain options: host, user, password, port and socket. If multiple instances of a given option are found, the last instance takes precedence, with one exception: For mysqld, the first instance ... Most MySQL programs can read startup options from option files (sometimes called configuration ...