PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: city ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
For example: mysql_upgrade -u root -p mysql_upgrade examines all tables in all databases for incompatibilities with the current version of MySQL. Note mysql_upgrade does not upgrade the contents of the time zone tables or help tables. Shut down and ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like RESTRICT. The MATCH clause in the SQL standard controls how NULL values in a composite (multiple-column) ...
https://dev.mysql.com/doc/refman/5.7/en/concurrent-inserts.html
If the variable is set to ALWAYS (or 2), concurrent inserts at the end of the table are permitted even for tables that have deleted rows. This is done to ensure that you can re-create an exact copy of your tables by applying the log during a backup ...If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Support for aliases on tables and columns as required by standard SQL. Support for MySQL-specific SHOW statements that retrieve information about databases, storage engines, tables, and indexes. You can refer to tables from different databases in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-identifying.html
If you enable a different file format using the innodb_file_format configuration option, the change only applies to newly created tables. Also, when you create a new table, the tablespace containing the table is tagged with the “earliest” or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system tablespace. You cannot define where within the system tablespace your tables are allocated. In a newly created ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The sections following this one describe options that pertain only to specific operations, such as table checking or repairing.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-database-objects.html
Some database objects such as tables and indexes have different limitations when using the NDBCLUSTER storage engine: Database and table names. When using the NDB storage engine, the maximum allowed length both for database names and for table ...