Search Results
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
EXPLAIN for full-text queries may show Select tables optimized away in the Extra column due to matching occurring during optimization; in this case, no table access need occur during later execution. The most common type of index involves a single ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html
You can specify them to select the compression algorithm used for the connection, and the numeric compression level used with that algorithm. This section describes use of URI-like connection strings or key-value pairs to specify how to establish ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
Suppose that jeffrey connects and issues the following query: mysql> SELECT CURRENT_USER(); +----------------+ | CURRENT_USER() | +----------------+ | @localhost | +----------------+ The result shown here indicates that the matching user table row ... When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper ...
https://dev.mysql.com/doc/refman/8.4/en/connection-compression-control.html
An exception is MySQL Shell, where the --compress command-line option remains current, and can be used to request compression without selecting compression algorithms. Connections to the server can use compression on the traffic between client and ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'connection%'; +------------------------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | ... This section describes how ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-foreign-key.html
Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. The ...
https://dev.mysql.com/doc/refman/8.4/en/constraints.html
Individual clients can set the SQL mode at runtime, which enables each client to select the behavior most appropriate for its requirements. MySQL enables you to work both with transactional tables that permit rollback and with nontransactional ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
To identify which column or columns use the SRID, use this query, replacing 4326 with the SRID of the definition you are trying to create: SELECT * FROM INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS WHERE SRS_ID=4326; With CREATE ... srs_attribute: { NAME ...