PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
An error occurs if the subquery produces multiple rows because a row subquery can return at most one row. Thus, the following query fails with a syntax error: SELECT * FROM t1 WHERE ROW(1) = (SELECT column1 FROM t2) Row constructors are legal in ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
For both InnoDB and MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum AUTO_INCREMENT column value plus one. An exclusive metadata lock on the table may ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. The following example uses DOUBLE to demonstrate how calculations that are done using floating-point operations are subject to ...A ...
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
If the server is run with external locking enabled, you can use myisamchk at any time for read operations such a checking tables. External locking affects server performance because the server must sometimes wait for other processes before it can ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
Merging cached changes at a later time, when affected pages are read into the buffer pool by other operations, avoids substantial random access I/O that would be required to read secondary index pages into the buffer pool from disk. The change ...
https://dev.mysql.com/doc/refman/5.7/en/system-schema.html
Time Zone System Tables These system tables contain time zone information: time_zone: Time zone IDs and whether they use leap seconds. For more information, see Section 5.1.13, “MySQL Server Time Zone Support”. Replication System Tables The ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-example.html
The second example is a little more advanced with some error checking. The second is followed by a GNUmake file that may be used for compiling instead. These two example programs should work without any changes on a Linux or FreeBSD system. For ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
This operation does not perform an implicit UNLOCK TABLES, so an error results if you perform the operation while there is any active LOCK TABLES or use it a second time without first releasing the locks acquired. FLUSH DES_KEY_FILE Reloads the DES ...| table_synonym WITH READ LOCK | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
Otherwise, an error occurs: ERROR 1123 (HY000): Can't initialize function 'keyring_key_generate'; The user is not privileged to execute this function. Attempts to use the functions without the keyring_udf plugin result in an error. Otherwise, an ...