PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-grants.html
Note To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER statement. SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
To create a test case that reproduces a problem with prepared statements, so that you can file a bug report. If you create a prepared statement within a stored routine, it is not deallocated when the stored routine ends. To guard against too many ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/mysql-command-options.html
To create or modify a login path file, use the mysql_config_editor utility. The DROP TABLE and CREATE TABLE statements are not executed because the default database is not db1, even though the statements name a table in db1. The INSERT and CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
Consider these statements that create a small data set that shows, for each employee in a company, the employee name and ID number, and the ID of the employee's manager. CTEs are similar to tables created with CREATE [TEMPORARY] TABLE but need not ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-multiple-get-range-query.html
The example uses the test.city table described in Creating a New Table and Column Mapping. When a range query finds multiple matching key-value pairs, results are returned in a key-value pair sequence. The examples use the test.city table described ... The daemon_memcached plugin supports multiple get operations (fetching multiple key-value pairs in a single memcached query) and range ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-relaylog.html
Successive relay log files are created using successive sequence numbers, beginning with 000001. For the default replication channel, relay log file names have the default form host_name-relay-bin.nnnnnn, where host_name is the name of the replica ... The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-key-rotation.html
When you rotate the binary log master key manually, MySQL Server takes the following actions in sequence: A new binary log encryption key is generated with the next available sequence number, stored on the keyring, and used as the new binary log ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
ARRAY is not supported except when used to create a multi-valued index in one of these statements, in which case it is required. Note CONVERT(), unlike CAST(), does not support multi-valued index creation or the ARRAY keyword. Other Uses for Cast ...