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/storage-engine-setting.html
To convert a table from one storage engine to another, use an ALTER TABLE statement that indicates the new engine: ALTER TABLE t ENGINE = InnoDB; See Section 15.1.20, “CREATE TABLE Statement”, and Section 15.1.9, “ALTER TABLE Statement”. By ... When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
ANALYZE TABLE is supported for partitioned tables, and you can use ALTER TABLE ... ANALYZE PARTITION to analyze one or more partitions; for more information, see Section 15.1.9, “ALTER TABLE Statement”, and Section 26.3.4, “Maintenance of ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE ...Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
In sandbox mode, no statements other than ALTER USER are permitted. When invoked with the --fido-register-factor option, the mysql client generates the ALTER USER statements required to perform registration. For information about the generated ALTER ... Note FIDO pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
Memory structures already allocated are reused, and runtime optimizations such as local caching of results already evaluated for aggregate functions can alter the results. This applies to statements such as UPDATE, INSERT, or DELETE (as before), but ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tables-table.html
Tables assigned to the system tablespace using CREATE TABLE or ALTER TABLE TABLESPACE=innodb_system have a SPACE_TYPE of General. INSTANT_COLS The number of columns that existed before the first instant column was added using ALTER TABLE ... When a ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
After the innodb_file_per_table option is configured, specify the ROW_FORMAT=COMPRESSED clause or KEY_BLOCK_SIZE clause, or both, in a CREATE TABLE or ALTER TABLE statement to create a compressed table in a file-per-table tablespace. The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. When running an in-place online DDL operation, the thread that runs the ALTER TABLE statement applies an online log of DML ... The ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
Note If you use ALTER TABLE on a locked table, it may become unlocked. For example, if you attempt a second ALTER TABLE operation, the result may be an error Table 'tbl_name' was not locked with LOCK TABLES. To handle this, lock the table again ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column values. In addition, you can define the ranges using columns of types other than integer types. RANGE COLUMNS ...