https://dev.mysql.com/fulltext-search-mecab.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation ...
https://dev.mysql.com/fulltext-search-ngram.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation, ...
https://dev.mysql.com/getting-information.html
Extra displays special information about columns: If a column was created with the AUTO_INCREMENT option, the value will be auto_increment rather than empty. What if you forget the name of a database or table, or what the structure of a given table ...
https://dev.mysql.com/innodb-locking.html
An AUTO-INC lock is a special table-level lock taken by transactions inserting into tables with AUTO_INCREMENT columns. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate ...
https://dev.mysql.com/innodb-recovery.html
For more information about how InnoDB handles auto-increment values, see Section 15.6.1.4, “AUTO_INCREMENT Handling in InnoDB”, and InnoDB AUTO_INCREMENT Counter Initialization. Topics include: Point-in-Time Recovery Recovery from Data ...
https://dev.mysql.com/insert-on-duplicate.html
ON DUPLICATE KEY UPDATE inserts or updates a row, the LAST_INSERT_ID() function returns the AUTO_INCREMENT value. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY ...
https://dev.mysql.com/known-issues.html
SELECT statements that insert zero or NULL values into an AUTO_INCREMENT column. SELECT with no ORDER BY, the SELECT may return rows in a different order (which results in a row having different ranks, hence getting a different number in the ...
https://dev.mysql.com/myisamchk-table-info.html
Auto increment key, Last value The key number associated the table's AUTO_INCREMENT column, and the most recently generated value for this column. To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The ...
https://dev.mysql.com/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...
https://dev.mysql.com/mysqldump.html
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to ...
