PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
The statements used to create and drop procedures, functions, triggers, and events are always safe, and are logged in statement format. To create or alter a stored function, you must have the SET_USER_ID privilege (or the deprecated SUPER ... The ...
https://dev.mysql.com/doc/refman/8.0/en/show-engine.html
For rwlocks, the Name field reports the source file where the rwlock is implemented, and the line number in the file where the rwlock is created. The remaining rows from the output of SHOW ENGINE NDB STATUS which are most likely to prove useful in ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
For example, you can add or delete columns, create or destroy indexes, change the type of existing columns, or rename columns or the table itself. To use ALTER TABLE, you need ALTER, CREATE, and INSERT privileges for the table. Renaming a table ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
Supported table DDL statements include CREATE, ALTER, and DROP statements for databases, tablespaces, tables, and indexes, and the TRUNCATE TABLE statement. Supported non-table DDL statements include: CREATE and DROP statements, and, if applicable, ...An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. A full-text index is defined as part of a CREATE TABLE statement or added to an ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
Default undo tablespaces are created at initialization time to provide a location for rollback segments that must exist before SQL statements can be accepted. Default undo tablespaces are created in the location defined by the innodb_undo_directory ... Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. In addition, changing the character ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-ngram.html
An ngram is a contiguous sequence of n characters from a given sequence of text. The ngram parser tokenizes a sequence of text into a contiguous sequence of n characters. Creating a FULLTEXT Index that Uses the ngram Parser To create a FULLTEXT ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
However, even if explicitly referenced, a column that is invisible in the existing table is visible in the new table: mysql> CREATE TABLE t1 (col1 INT, col2 INT INVISIBLE); mysql> CREATE TABLE t2 AS SELECT col1, col2 FROM t1; mysql> SHOW CREATE ...