PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/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)); GeometryCollection(g [, g] ...) Constructs a GeometryCollection value from the geometry arguments. MySQL ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/en/group-replication-view-changes.html
This section explains the process which controls how the view change identifier is incorporated into a binary log event and written to the log, The following steps are taken: Begin: Stable Group All servers are online and processing incoming ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 23.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/5.7/en/information-schema-files-table.html
The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB Cluster, this table also provides information about the files in which NDB Cluster Disk Data tables are stored. For additional information ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
You can filter, sort, concatenate, and transform the results from INFORMATION_SCHEMA queries into whatever format your application needs, such as a data structure or a text representation to parse. INFORMATION_SCHEMA provides access to database ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
Copy all InnoDB data files (ibdata files and .ibd files) into a safe place. Dumped tables are stored into text files that are human-readable, so spotting table corruption becomes easier. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Group sets of related DML operations into transactions by bracketing them with START TRANSACTION and COMMIT statements. Enable the innodb_file_per_table variable or use general tablespaces to put the data and indexes for tables into separate files ...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/5.7/en/innodb-compression-syntax-warnings.html
The “non-strict” behavior lets you import a mysqldump file into a database that does not support compressed tables, even if the source database contained compressed tables. To import the dump file into a new database, and have the tables ...