PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-commands.html
mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that mysql itself interprets. For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-cjk.html
This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) issues. What problems should I be aware of when working with the Big5 ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-command-options.html
mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option file. For information about option files used by MySQL programs, see Section 6.2.2.2, “Using Option Files”.
https://dev.mysql.com/doc/refman/9.7/en/comp-err.html
comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error codes. It compiles the errmsg.sys file from text-format error information in MySQL source distributions: The error ...
https://dev.mysql.com/doc/refman/9.7/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-gipks.html
MySQL 9.7 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server automatically adds a ...
https://dev.mysql.com/doc/refman/9.7/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/9.7/en/invisible-columns.html
An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must continue to ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog.html
The server's binary log consists of files containing “events” that describe modifications to database contents. To display their contents in text format, use the mysqlbinlog utility. You can also use mysqlbinlog to display the contents of relay ...