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/commit.html
In read-only mode, it remains possible to change tables created with the TEMPORARY keyword using DML statements. The BEGIN statement differs from the use of the BEGIN keyword that starts a BEGIN ... The optional WORK keyword is supported for COMMIT ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-dns-srv.html
For example, a client might support specifying the name within a URI-like connection string or as a key-value pair. In the Domain Name System (DNS), a SRV record (service location record) is a type of resource record that enables a client to ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 5 filtered: 20.00 Extra: Using where 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS; ... Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during ...
https://dev.mysql.com/doc/refman/8.0/en/corrupted-myisam-tables.html
Typical symptoms of a corrupt table are: You get the following error while selecting data from the table: Incorrect key file for table: '...'. Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html
LIKE does not preserve any DATA DIRECTORY or INDEX DIRECTORY table options that were specified for the original table, or any foreign key definitions. LIKE to create an empty table based on the definition of another table, including any column ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by itself is not very interesting, the table should contain other ...
https://dev.mysql.com/doc/refman/8.0/en/delete-optimization.html
To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete all ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html
The JSON output from the docker inspect command on the container includes a Mount key, whose value provides information on the data directory volume: $> docker inspect mysql1 ... 180921 22:06:52 PCR1 INFO: Last MySQL binlog file position 0 155, file ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Only a limited number of binaries are ...
https://dev.mysql.com/doc/refman/8.0/en/error-interfaces.html
SHOW ENGINE INNODB STATUS statement output includes information about the most recent foreign key error if a CREATE TABLE statement for an InnoDB table fails. Error messages can originate on the server side or the client side, and each error ...