Search Results
https://dev.mysql.com/doc/refman/8.4/en/gis-mysql-specific-functions.html
For example, you can insert the geometry return value from Point() directly into a POINT column: INSERT INTO t1 (pt_col) VALUES(Point(1,2)); GeomCollection(g [, g] ...) Constructs a GeomCollection value from the geometry arguments. MySQL provides a ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. Also, the data was inserted into the table and ... The process of starting a group for the first time is called ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs.
https://dev.mysql.com/doc/refman/8.4/en/innodb-best-practices.html
Foreign keys also propagate deletes and updates to all affected tables, and prevent insertion of data in a child table if the corresponding IDs are not present in the parent table. Group sets of related DML operations into transactions by bracketing ...Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-defragmenting.html
Random insertions into or deletions from a secondary index can cause the index to become fragmented. If the insertions into an index are always ascending and records are deleted only from the end, the InnoDB filespace management algorithm ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
As a final step, insert a row into table t1 (TABLE_ID = 71) and view the data in the INNODB_TABLESTATS table. mysql> INSERT INTO t1 VALUES(5, 'abc', 'def'); Query OK, 1 row affected (0.06 sec) mysql> SELECT * FROM ... You can extract metadata about ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-failure-conditions.html
For example, you might insert duplicate values into a column while a unique index is being created, or you might insert NULL values into a column while creating a primary key index on that column. The failure of an online DDL operation is typically ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
If the intent is for there to be a correspondence between rows inserted and locks acquired, that intent is not satisfied. MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable ...