PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-databases.html
On Unix, symlink a database using this procedure: Create the database using CREATE DATABASE: mysql> CREATE DATABASE mydb1; Using CREATE DATABASE creates the database in the MySQL data directory and permits the server to update the data dictionary ...Stop the server to ensure that no activity occurs in the new database while it is being ...
https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html
For some statements, MySQL creates temporary SQL tables that are not hidden and have names that begin with #sql. Some SELECT queries creates temporary SQL tables to hold intermediate results. DDL operations that rebuild the table and are not ... On ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-set.html
The binary character set is the character set for binary strings, which are sequences of bytes. Comparison and sorting are based on numeric byte values, rather than on numeric character code values (which for multibyte characters differ from ...
https://dev.mysql.com/doc/refman/8.0/en/condition-filtering.html
It depends on a constant value or values from earlier tables in the join sequence. In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html
The following methods are permissible: AUTO MYSQL41 SHA256_MEMORY FROM_CAPABILITIES FALLBACK PLAIN For X Protocol connections, any configured auth-method is overridden to this sequence of authentication methods: MYSQL41, SHA256_MEMORY, PLAIN. You ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-curve.html
A Curve is a one-dimensional geometry, usually represented by a sequence of points. Particular subclasses of Curve define the type of interpolation between points. A Curve is simple if it does not pass through the same point twice, with the ...
https://dev.mysql.com/doc/refman/8.0/en/index-merge-optimization.html
The Index Merge access method retrieves rows with multiple range scans and merges their results into one. This access method merges index scans from a single table only, not scans across multiple tables. The merge can produce unions, intersections, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-fields-table.html
When a column is dropped, the remaining columns are reordered so that the sequence has no gaps. The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-being-deleted-table.html
This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence value generated by InnoDB when the table contains no suitable column. The INNODB_FT_BEING_DELETED table provides a snapshot of the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-deleted-table.html
This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence value generated by InnoDB when the table contains no suitable column. The INNODB_FT_DELETED table stores rows that are deleted ...