PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html
A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER TABLE or CREATE INDEX. Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-enabling.html
The innodb_file_format setting is not applicable when using the TABLESPACE [=] innodb_system table option with CREATE TABLE or ALTER TABLE to store a DYNAMIC table in the system tablespace. The innodb_file_format configuration option enables an ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. Reserved words are permitted as identifiers if you quote them as described in Section 9.2, ...This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-reserved-words.html
An example of this is using a table column named virtual on a 5.6 source that is replicating to a 5.7 or higher replica because VIRTUAL is a reserved word beginning in MySQL 5.7. Replication can fail in such cases with Error 1064 You have an error ... You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
For statements affecting databases only (that is, CREATE DATABASE, DROP DATABASE, and ALTER DATABASE), database-level options always take precedence over any --replicate-wild-do-table options. You should not use these options to control which ... If ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
Stored routines can be dropped with the DROP PROCEDURE and DROP FUNCTION statements (see Section 13.1.27, “DROP PROCEDURE and DROP FUNCTION Statements”), and altered with the ALTER PROCEDURE and ALTER FUNCTION statements (see Section 13.1.6, ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
This applies to the ALTER USER, CREATE USER, GRANT, and SET PASSWORD statements, and passwords given as arguments to the PASSWORD() function. Note For statements that assign, modify, or generate account passwords (ALTER USER, CREATE USER, GRANT, and ... The validate_password plugin serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/refman/5.7/en/access-control.html
For example: SHOW GRANTS FOR 'joe'@'office.example.com'; SHOW GRANTS FOR 'joe'@'home.example.com'; Internally, the server stores privilege information in the grant tables of the mysql system database. The MySQL server reads the contents of these ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. Other grant tables indicate privileges an account has for ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
InnoDB does not keep an internal count of rows in a table because concurrent transactions might “see” different numbers of rows at the same time. For a faster count, create a counter table and let your application update it according to the ...