PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-restrictions.html
Identifiers are stored in mysql database tables (user, db, and so forth) using utf8, but identifiers can contain only characters in the Basic Multilingual Plane (BMP). FULLTEXT indexes cannot be created on a column that uses any of these character ...The ucs2, utf16, utf16le, and utf32 character sets have the following restrictions: None of them can be used as the client character ...
https://dev.mysql.com/doc/refman/5.7/en/comments.html
(Under some conditions, nested comments might be permitted, but usually are not, and users should avoid them.) MySQL Server supports certain variants of C-style comments. MySQL Server supports three comment styles: From a # character to the end of ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
In read-only mode, it remains possible to change tables created with the TEMPORARY keyword using DML statements. Rolling back can be a slow operation that may occur implicitly without the user having explicitly asked for it (for example, when an ...
https://dev.mysql.com/doc/refman/5.7/en/connectors-apis.html
Connector/NET enables developers to create .NET applications that connect to MySQL. Native drivers are also easier for end users to build and deploy because no copy of the MySQL client libraries is needed to build the native driver components.
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
ddl_log.log is not created until it is actually needed for recording metadata statements, and is removed following a successful start of mysqld. There are no user-configurable server options or variables associated with this file. The DDL log, or ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
For example, the following statement finds rows matching the WHERE clause, sorts them by timestamp_column, and deletes the first (oldest) one: DELETE FROM somelog WHERE user = 'jcole' ORDER BY timestamp_column LIMIT 1; ORDER BY also helps to delete ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
The overhead of index creation is negligible compared to the cost of query execution without the index. If ref access would result in higher cost than some other access method, the optimizer creates no index and loses nothing. The optimizer handles ...
https://dev.mysql.com/doc/refman/5.7/en/error-interfaces.html
SHOW ENGINE INNODB STATUS statement output includes information about the most recent foreign key error if a CREATE TABLE statement for an InnoDB table fails. The client may display the error message so the user can take corrective measures, ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
We also know of users who use MySQL Server with 200,000 tables and about 5,000,000,000 rows. MySQL Connector/NET enables developers to easily create .NET applications that require secure, high-performance data connectivity with MySQL. This section ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 24.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description Deprecated INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...