PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
SELECT id, data INTO @x, @y FROM test.t1 LIMIT 1; INTO var_list can also be used with a TABLE statement, subject to these restrictions: The number of variables must match the number of columns in the table. If the table contains more than one row, ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. This is done to ensure that you can re-create an exact copy of your tables by applying the log during a backup operation. The number increases each time the server creates a new log file, thus creating an ordered series of ...It also contains events for statements that ...
https://dev.mysql.com/doc/refman/8.0/en/charset-column.html
CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET latin1 COLLATE latin1_bin; The character set and collation are specified for the column, so they are used. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET ...To see the default collation for each character set, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS ... Every ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
For example, the CREATE USER privilege enables not only creation of new accounts, but modification and removal of existing accounts. Without the system user concept, a user who has the CREATE USER privilege can modify or drop any existing account, ... As of MySQL 8.0.16, MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/refman/8.0/en/handler-scope.html
However, SQLSTATE handlers take precedence over SQLEXCEPTION handlers, so if the table t is nonexistent, the DROP TABLE statement raises a condition that activates the SQLSTATE handler: mysql> CALL p1(); +--------------------------------+ | msg | ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
For example: CREATE TABLE test (blob_col BLOB, INDEX(blob_col(10))); Prefixes can be up to 767 bytes long for InnoDB tables that use the REDUNDANT or COMPACT row format. Note Prefix limits are measured in bytes, whereas the prefix length in CREATE ...The maximum number of indexes per table and the maximum index length is defined per storage ... The most common type of index involves a single column, storing copies of the values from that ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
MySQL 8.0.16 and higher includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful ...Within statements considered for rewrite, instances of the following clauses are rewritten and each instance replaced by a single space: ENCRYPTION DATA DIRECTORY (at the table and partition levels) INDEX DIRECTORY (at the table and partition levels) Rewriting does not depend on ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-backup-id.html
This table provides a way to find the ID of the backup started most recently for this cluster. The backup_id table contains a single column id, which corresponds to a backup ID taken using the ndb_mgm client START BACKUP command.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-config-values.html
The config_values table provides information about the current state of node configuration parameter values. Each row in the table corresponds to the current value of a parameter on a given node. The config_values table contains the following ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-foreign-keys.html
The foreign_keys table provides information about foreign keys on NDB tables.