https://dev.mysql.com/extensions-to-ansi.html
If you add a version number after the ! character, the syntax within the comment is executed only if the MySQL version is greater than or equal to the specified version number. String comparisons are case-insensitive by default, with sort ordering ... MySQL Server supports some extensions that you probably will not find in other SQL ...
https://dev.mysql.com/fulltext-search.html
Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns. There are no special operators, with the exception of double quote (") characters. MATCH (col1,col2,...) AGAINST (expr ...
https://dev.mysql.com/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
https://dev.mysql.com/get-diagnostics.html
GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ... (You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The ...
https://dev.mysql.com/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/glossary.html
backticks Identifiers within MySQL SQL statements must be quoted using the backtick character (`) if they contain special characters or reserved words. These techniques have different characteristics in terms of size and representation of the backup ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/innodb-auto-increment-handling.html
To make this clear, consider an example that uses this table: CREATE TABLE t1 ( c1 INT(11) NOT NULL AUTO_INCREMENT, c2 VARCHAR(10) DEFAULT NULL, PRIMARY KEY (c1) ) ENGINE=InnoDB; Suppose that there are two transactions running, each inserting rows ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/innodb-autocommit-commit-rollback.html
shell> mysql test mysql> CREATE TABLE customer (a INT, b CHAR (20), INDEX (a)); Query OK, 0 rows affected (0.00 sec) mysql> -- Do a transaction with autocommit turned on. If autocommit mode is enabled, each SQL statement forms a single transaction ...
https://dev.mysql.com/innodb-columns-table.html
1 = VARCHAR, 2 = CHAR, 3 = FIXBINARY, 4 = BINARY, 5 = BLOB, 6 = INT, 7 = SYS_CHILD, 8 = SYS, 9 = FLOAT, 10 = DOUBLE, 11 = DECIMAL, 12 = VARMYSQL, 13 = MYSQL, 14 = GEOMETRY. PRTYPE The InnoDB “precise type”, a binary value with bits representing ...For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/innodb-compression-tuning.html
Whether to adjust the size of the buffer pool based on run-time performance characteristics, such as the amount of time the system spends compressing and uncompressing data. When to Use Compression In general, compression works best on tables that ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
