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/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/doc/refman/8.0/en/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/doc/refman/8.0/en/information-schema-columns-table.html
The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was made. Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
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 KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and debugging instructions in Section 2.1, “General Installation Guidance”, and Section 7.9, “Debugging MySQL”. The following problems are known: Subquery optimization for IN is not as effective as for ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html
ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB API. ndb_import requires a connection to an NDB management server (ndb_mgmd) to function; it does not require a connection to a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/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 ...