PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
The BINARY and VARBINARY data types are distinct from the CHAR BINARY and VARCHAR BINARY data types. For cases of truncation, to cause an error to occur (rather than a warning) and suppress insertion of the value, use strict SQL mode. For those ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
Within the statement, ? characters can be used as parameter markers to indicate where data values are to be bound to the query later when you execute it. This means that if the new statement contains an error and cannot be prepared, an error is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
TABLE_SCHEMA The name of the schema (database) to which the table belongs. For partitioned InnoDB tables, the row count given in the TABLE_ROWS column is only an estimated value used in SQL optimization, and may not always be exact. DATA_LENGTH The ...The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/8.0/en/user-variables.html
A value having the JSON data type is converted to a string with a character set of utf8mb4 and a collation of utf8mb4_bin. This does not currently include contexts that explicitly require a literal value, such as in the LIMIT clause of a SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-memory.html
This space must be available on the same file system as the original data file, as the copy is created in the same directory as the original. This space must be available on the same file system as the original data file. When performing repair ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync.html
Compared to asynchronous replication, semisynchronous replication provides improved data integrity, because when a commit returns successfully, it is known that the data exists in at least two places. Compared to fully synchronous replication, ...
https://dev.mysql.com/doc/refman/8.0/en/postinstallation.html
For other platforms and installation types, you must initialize the data directory manually. This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables.
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE ...This ...
https://dev.mysql.com/doc/refman/8.0/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...(To maximize performance, queries try to read as few data blocks as possible from disk; tables with only a few columns can fit more rows in each data ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-spatial-reference-systems-table.html
The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in the ST_SPATIAL_REFERENCE_SYSTEMS table are based on the European Petroleum Survey Group (EPSG) data set, ...