Search Results
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
It does support ORDER BY operations, BLOB columns, and spatial data types (see Section 13.4.1, “Spatial Data Types”). The AUTO_INCREMENT column can have either a unique or nonunique index. Attempting to create an index on any other column ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
For storage engines that support nonspatial indexing of spatial columns, the engine creates a B-tree index. The optimizer can use spatial indexes defined on columns that are SRID-restricted. For more information on indexing spatial columns, see ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
(To update the cached values at any time for a given table, use ANALYZE TABLE.) If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics columns. Queries on ... Use of ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
You need only the SELECT privilege for any columns that are only read, such as those named in the WHERE clause. Auto-Increment Columns If you delete the row containing the maximum value for an AUTO_INCREMENT column, the value is not reused for a ...
https://dev.mysql.com/doc/refman/8.4/en/extended-show.html
To use a WHERE clause with SHOW CHARACTER SET, you would refer to those column names. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns. MATCH() takes a comma-separated list that names the columns to be searched. This rules out, for example, a table column ...
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
Within a stored procedure p(), we attempt to insert two values into a table that contains a TEXT NOT NULL column. The column prohibits NULL values, so the first insert succeeds but the second causes an exception. GET [CURRENT | STACKED] DIAGNOSTICS ...
https://dev.mysql.com/doc/refman/8.4/en/handler.html
If you have a multiple-column index, specify the index column values as a comma-separated list. Either specify values for all the columns in the index, or specify values for a leftmost prefix of the index columns. Suppose that an index my_idx ...
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as identifiers. Use of the dollar sign as the first character in the ...