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/spatial-types.html
For example, a system view named GEOMETRY_COLUMNS contains a description of geometry columns, one row for each geometry column in the database. The Open Geospatial Consortium publishes the OpenGIS® Implementation Standard for Geographic information ... The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications that manage spatial ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema.html
You can view a list of InnoDB INFORMATION_SCHEMA tables by issuing a SHOW TABLES statement on the INFORMATION_SCHEMA database: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB%'; For table definitions, see Section 24.4, “INFORMATION_SCHEMA ... This section provides information and usage examples for InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
When you create a CSV table, the server creates a table format file in the database directory. If you examine the test.CSV file in the database directory created by executing the preceding statements, its contents should look like this: "1","record ... The CSV storage engine stores data in text files using comma-separated values ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create.html
Create the table on the local server with an identical table definition, but adding the connection information that links the local table to the remote table. You can either create the local table and specify the connection string (containing the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-management.html
Within these constraints, InnoDB tries to optimize the database work and the organization of disk files to minimize the amount of disk I/O. Sometimes, I/O is postponed until the database is not busy, or until everything needs to be brought to a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations.html
You can report any discrepancies that you encounter to the MySQL bugs database using the instructions given in Section 1.5, “How to Report Bugs or Problems”. See Previous NDB Cluster Issues Resolved in NDB Cluster 8.0 for a list of issues in ...
https://dev.mysql.com/doc/refman/5.7/en/binlog-replication-configuration-overview.html
The information in the binary log is stored in different logging formats according to the database changes being recorded. This section describes replication between MySQL servers based on the binary log file position method, where the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-find-table.html
Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase. You can check which tables are in the default database with SHOW TABLES.
https://dev.mysql.com/doc/refman/5.7/en/alter-instance.html
The statement supports these actions: ALTER INSTANCE ROTATE INNODB MASTER KEY This action rotates the master encryption key used for InnoDB tablespace encryption. To perform this action, a keyring plugin must be installed and configured. If one of ... ALTER INSTANCE ROTATE INNODB MASTER KEY ALTER INSTANCE, introduced in MySQL 5.7.11, defines actions applicable to a MySQL server ...