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/transport-protocols.html
For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based on several transport protocols: TCP/IP, Unix socket file, named pipe, and shared memory. This section describes how to ...
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-partitioning.html
When the replica's copy of the table is partitioned but the source's copy is not, statements acting on partitions cannot be run on the source without causing errors there. Replication is supported between partitioned tables as long as they use the ...
https://dev.mysql.com/doc/refman/5.7/en/history.html
We started out with the intention of using the mSQL database system to connect to our tables using our own fast low-level (ISAM) routines. However, after some testing, we came to the conclusion that mSQL was not fast enough or flexible enough for ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/operator-precedence.html
Operator precedences are shown in the following list, from highest precedence to the lowest. Operators that are shown together on a line have the same precedence. When used as a comparison operator, it has the same precedence as <=>, >=, >, <=, <, ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. That might be useful, for example, after you have ... The name of the performance_schema database is lowercase, as are the names of tables within ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
(See Section 5.1.10, “Server SQL Modes”.) The following discussion mentions strict mode (selected by the STRICT_ALL_TABLES or STRICT_TRANS_TABLES mode values) and ERROR_FOR_DIVISION_BY_ZERO. To turn on all restrictions, you can simply use ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
deleting from reference tables The server is executing the second part of a multiple-table delete and deleting the matched rows from the other tables. updating reference tables The server is executing the second part of a multiple-table update and ...This state is used even if the table could not be created due to some ... The following list describes thread State values that are associated with ...