PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
Suppose that a customer table containing customer records has these columns: id: Customer ID number. Thus, even though ssn is defined as VARCHAR(11), if the ssn column has a multibyte character set, it may appear to be longer than 11 bytes when ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
When the date argument is a TIMESTAMP column, UNIX_TIMESTAMP() returns the internal timestamp value directly, with no implicit “string-to-Unix-timestamp” conversion. If you want to subtract UNIX_TIMESTAMP() columns, you might want to cast them ... This section describes the functions that can be used to manipulate temporal ...
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-tablespace-encryption.html
Can indexed columns be encrypted? InnoDB data-at-rest encryption supports all indexes transparently. Is data decrypted for users who are authorized to see it? A.17.2. What are the encryption algorithms used with InnoDB data-at-rest encryption? ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-server.html
See the following table for information on the correspondence between parameters in a connection string, options in the CREATE SERVER statement, and the columns in the mysql.servers table. For reference, the format of the CONNECTION string is as ...