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/charset-literal.html
To see the default collation for each character set, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. The following examples show that escape processing occurs using character_set_connection even in the ...
https://dev.mysql.com/doc/refman/5.7/en/collation-diagnostics.html
Problems with collations generate warnings that clients can display with SHOW WARNINGS. The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file: Unknown tags are written to the error log. For example, the ...
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
For additional information and examples showing how to use them, see Section 4.2.4, “Connecting to the MySQL Server Using Command Options”. For example, connections on Unix to localhost are made using a Unix socket file by default: mysql ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the ...
https://dev.mysql.com/doc/refman/5.7/en/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. The optimizer has a set of compiled-in default “cost constants” available to it to make ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
For example: CREATE TABLE lookup (id INT) ENGINE = MEMORY; CREATE INDEX id_index ON lookup (id) USING BTREE; Table 13.1, “Index Types Per Storage Engine” shows the permissible index type values supported by different storage engines. The ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
The following query shows, for each pet, the birth date, the current date, and the age in years. MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To ...
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connection-protocols-ciphers.html
To determine the value of tls_version at runtime, use this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'tls_version'; +---------------+-----------------------+ | Variable_name | Value | +---------------+-----------------------+ | tls_version | ...
https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
If you're retrieving the value of an expression rather than a table column (as in the example just shown), mysql labels the column using the expression itself. mysql shows how many rows were returned and how long the query took to execute, which ...