PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; For more information, see Section 13.1.18.3, “CREATE TABLE ... | ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns.
https://dev.mysql.com/doc/refman/5.7/en/alter-table-examples.html
Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step is to drop the original table and then rename the copy: DROP TABLE t1; ALTER TABLE t2 RENAME t1; . For NDB tables, it is also possible to ...For MyISAM tables, you can set the first sequence number by executing SET INSERT_ID=value before ALTER TABLE or by using the AUTO_INCREMENT=value table ...
https://dev.mysql.com/doc/refman/5.7/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all ...Suppose that the server's default character set was latin1 and col1 is defined as CHAR(50) but its contents are sjis ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
You need only the SELECT privilege for any columns that are only read, such as those named in the WHERE clause. Auto-Increment Columns If you delete the row containing the maximum value for an AUTO_INCREMENT column, the value is not reused for a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-columns-table.html
The INNODB_SYS_COLUMNS table provides metadata about InnoDB table columns, equivalent to the information from the SYS_COLUMNS table in the InnoDB data dictionary. The INNODB_SYS_COLUMNS table has these columns: TABLE_ID An identifier representing ...For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA System ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
It is deleting only from the first table, and saving columns and offsets to be used for deleting from the other (reference) tables. rename result table The thread is processing an ALTER TABLE statement, has created the new table, and is renaming it ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/5.7/en/log-file-maintenance.html
For the latter logs, to cause a new log file to be created on Unix, rename the current log file first before flushing it. To rename the general query log or slow query log at runtime, first connect to the server and disable the log: SET GLOBAL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.html
This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. It is sometimes useful in diagnosing and repairing corrupted or damaged NDB tables containing BLOB ...These options cause ndb_blob_tool to check for orphaned BLOB parts, remove any orphaned BLOB parts, and generate a dump file listing orphaned BLOB parts, respectively, and are described in more detail later in this ...