PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-restrictions.html
FULLTEXT indexes cannot be created on a column that uses any of these character sets. However, you can perform IN BOOLEAN MODE searches on the column without an index. Identifiers are stored in mysql database tables (user, db, and so forth) using ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
MySQL requires that foreign key columns be indexed; if you create a table with a foreign key constraint but no index on a given column, an index is created. You can obtain information about foreign keys from the Information Schema KEY_COLUMN_USAGE ... Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data ...
https://dev.mysql.com/doc/refman/5.7/en/crashing.html
If you have a problem with tables containing dynamic-length rows and you are using only VARCHAR columns (not BLOB or TEXT columns), you can try to change all VARCHAR to CHAR with ALTER TABLE. Each MySQL version is tested on many platforms before it ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
The options that you specify are used to populate the columns in the mysql.servers table. The table columns are Server_name, Host, Db, Username, Password, Port and Socket. CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
An alias (age) is used to make the final output column label more meaningful. What if you want to know which animals have birthdays next month? For this type of calculation, year and day are irrelevant; you simply want to extract the month part of ... MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-system-variables.html
The last column indicates whether the scope for each variable is Global, Session, or both. This differs from the ENUM data type used for table columns, for which the first enumeration value corresponds to 1. Many server system variables are dynamic ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-migration.html
The VARCHAR column type now retains trailing spaces in all storage engines. MEMORY tables (formerly known as HEAP tables) can also contain VARCHAR columns. Where can I find information on how to upgrade or downgrade MySQL? A.8.2. How has storage ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
How do I know how late a replica is compared to the source? In other words, how do I know the date of the last statement replicated by the replica? Check the Seconds_Behind_Master column in the output from SHOW REPLICA | SLAVE STATUS. (This is why ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-triggers.html
MySQL does have specific special behavior for some TIMESTAMP columns, as well as for columns which are defined using AUTO_INCREMENT. Where can I find the documentation for MySQL 5.7 triggers? A.5.2. Is there a way to view all triggers in a given ...