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/identifier-case-sensitivity.html
The lower_case_table_names system variable also affects how the server handles identifier case sensitivity, as described later in this section. How table and database names are stored on disk and used in MySQL is affected by the ... In MySQL, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
lower_case_table_names Command-Line Format --lower-case-table-names[=#] System Variable lower_case_table_names Scope Global Dynamic No Type Integer Default Value (macOS) 2 Default Value (Unix) 0 Default Value (Windows) 1 Minimum Value 0 Maximum ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
A convenient way to accomplish this is to add lower_case_table_names=1 to the [mysqld] section of your my.cnf or my.ini file before creating databases, tablespaces, or tables: [mysqld] lower_case_table_names=1 When running ALTER TABLE ... This ...
https://dev.mysql.com/doc/refman/5.7/en/revoke.html
If the grant tables hold privilege rows that contain mixed-case database or table names and the lower_case_table_names system variable is set to a nonzero value, REVOKE cannot be used to revoke these privileges. (GRANT does not create such rows when ...The REVOKE statement enables system administrators to revoke privileges from MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
Lower Case Sets the lower_case_table_names option value to 1 (default), in which table names are stored in lowercase on disk and comparisons are not case-sensitive. Preserve Given Case Sets the lower_case_table_names option value to 2, in which ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
If you are running Windows, please verify the value of lower_case_table_names using the SHOW VARIABLES LIKE 'lower_case_table_names' statement. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
If the grant tables hold privilege rows that contain mixed-case database or table names and the lower_case_table_names system variable is set to a nonzero value, REVOKE cannot be used to revoke these privileges. (GRANT does not create such rows when ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
Names of databases and user tables are in the same case as they were originally defined, possibly influenced by the lower_case_table_names setting. The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new ...