Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-tablespace.html
It can be used to add a new data file to, or to drop a data file from an NDB tablespace. It can also be used to rename an NDB Cluster Disk Data tablespace, rename an InnoDB general tablespace, encrypt an InnoDB general tablespace, or mark an InnoDB ...You may optionally follow size with a one-letter abbreviation for an order of magnitude, similar to those used in ...
https://dev.mysql.com/doc/refman/8.4/en/any-in-some-subqueries.html
The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if table t2 contains (20,10), or if table t2 is empty. The expression is unknown (that is, NULL) if table t2 ...When ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be installed. If the plugin is installed without the accompanying audit tables and functions needed for rule-based ...
https://dev.mysql.com/doc/refman/8.4/en/charset-examples.html
Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE latin2_bin; Here we have a column with a latin1 character set and a latin1_german1_ci ... The ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. To drop spatial indexes, use ALTER TABLE or DROP INDEX: With ALTER TABLE: ALTER TABLE geom DROP ...For storage engines that support nonspatial indexing of spatial columns, the engine creates a B-tree ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
You can obtain information about existing stored procedures using the ROUTINES table in the INFORMATION_SCHEMA database (see Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”). For a database named dbname, use this query on the ...Where ...
https://dev.mysql.com/doc/refman/8.4/en/handler-scope.html
However, SQLSTATE handlers take precedence over SQLEXCEPTION handlers, so if the table t is nonexistent, the DROP TABLE statement raises a condition that activates the SQLSTATE handler: mysql> CALL p1(); +--------------------------------+ | msg | ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl.html
The online DDL feature provides support for instant and in-place table alterations and concurrent DML. Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for ...For in-place operations, the ability to adjust the balance between performance and concurrency during DDL operations using the LOCK ...
https://dev.mysql.com/doc/refman/8.4/en/kill.html
Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID column of the Performance Schema threads table. ALTER TABLE operations ... KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
If you invoke mysqldump with the --tab=dir_name option, it uses dir_name as the output directory and dumps tables individually in that directory using two files for each table. For a table named t1, the files are named t1.sql and t1.txt. The .sql ...