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-collation-information-schema.html
For example, tables named city, CITY, and City can all exist simultaneously. String columns in INFORMATION_SCHEMA tables have a collation of utf8_general_ci, which is case-insensitive. However, for values that correspond to objects that are ...
https://dev.mysql.com/doc/refman/5.7/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all ...
https://dev.mysql.com/doc/refman/5.7/en/charset-gb18030.html
In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information technology — Chinese coded character set”, which is the official character set of the People's Republic of China (PRC).
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE can also check views for problems, such as tables that are referenced in the view definition that no longer exist. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. To ...
https://dev.mysql.com/doc/refman/5.7/en/compatibility.html
The SQL standard has been evolving since 1986 and several versions exist. This section describes how MySQL relates to the ANSI/ISO SQL standards. MySQL Server has many extensions to the SQL standard, and here you can find out what they are and how ...
https://dev.mysql.com/doc/refman/5.7/en/compilation-problems.html
When CMake starts, it looks for that file and reads its contents if it exists, on the assumption that the information is still correct. If you do reconfigure, take note of the following: If CMake is run after it has previously been run, it may use ...
https://dev.mysql.com/doc/refman/5.7/en/conditions-and-parameters.html
If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of RESIGNAL pops the Diagnostics Area stack, thus signalling the exception (that is, the information that existed before entry into the handler).
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-procedure.html
For this reason, avoid using the names of existing SQL functions for your own stored routines. By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as ...
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-columns.html
Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE statement to add or drop a spatial column to or from an existing table: ALTER TABLE geom ADD pt POINT; ALTER TABLE geom DROP ... MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER ...