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/temporary-table-problems.html
Use ALTER TABLE instead: ALTER TABLE old_name RENAME new_name; You cannot refer to a TEMPORARY table more than once in the same query. Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
auto-increment A property of a table column (specified by the AUTO_INCREMENT keyword) that automatically adds an ascending sequence of values in the column. It provides useful information for the query optimizer, because the column is known to be ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
Database, table, column, and routine names can be up to 64 characters. Object Quoting Guidelines Several objects within GRANT statements are subject to quoting, although quoting is optional in many cases: Account, database, table, column, and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-auto-increment.html
Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step is to drop the original table and then rename the copy: DROP t1; ALTER TABLE t2 RENAME t1; See also Section B.3.6.1, “Problems with ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
DISTINCT with ORDER BY does not work inside GROUP_CONCAT() if you do not use all and only those columns that are in the DISTINCT list. When inserting a big integer value (between 263 and 264−1) into a decimal or string column, it is inserted as a ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
The following statement would not work because it refers to a table both as my_table and as MY_TABLE: mysql> SELECT * FROM my_table WHERE MY_TABLE.col=1; Column, index, stored routine, and event names are not case-sensitive on any platform, nor are ... In MySQL, databases correspond to directories within the data ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which account names are written in SQL statements. Its value is constructed from the User and Host columns of the user ... Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
mysql_upgrade checks mysql.user system table rows and, for any row with an empty plugin column, sets that column to 'mysql_native_password' or 'mysql_old_password' depending on the hash format of the Password column value. If you have a user created ... Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that might have been ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-invoked.html
The ORIGINATOR column in the Information Schema EVENTS table and the originator column in mysql.event store this information. You can do this by storing in a separate table the event names from the SELECT statement shown previously, or using ALTER ... Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--safe-user-create Command-Line Format --safe-user-create[={OFF|ON}] Type Boolean Default Value OFF If this option is enabled, a user cannot create new MySQL users by using the GRANT statement unless the user has the INSERT privilege for the ...