MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 11 to 19 of 19 total results

« Previous
1
2
Next »

24.4.17 The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table

https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-columns-table.html

These names can be uppercase or lowercase depending on the lower_case_table_names setting. The INNODB_SYS_COLUMNS table provides metadata about InnoDB table columns, equivalent to the information from the SYS_COLUMNS table in the InnoDB data ...

B.3.7 Known Issues in MySQL

https://dev.mysql.com/doc/refman/5.7/en/known-issues.html

Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on ... This ...

17.7.1 Group Replication System Variables

https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html

These conditions apply to the following system variables: group_replication_single_primary_mode group_replication_enforce_update_everywhere_checks group_replication_gtid_assignment_block_size default_table_encryption lower_case_table_names ... This ...

16.4.1.37 Replication and Variables

https://dev.mysql.com/doc/refman/5.7/en/replication-features-variables.html

To help reduce possible confusion, we recommend that you always use the same setting for the lower_case_table_names system variable on both source and replica, especially when you are running MySQL on platforms with case-sensitive file systems.

16.2.5 How Servers Evaluate Replication Filtering Rules

https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html

Note All replication filtering options follow the same rules for case sensitivity that apply to names of databases and tables elsewhere in the MySQL server, including the effects of the lower_case_table_names system variable. If a replication ...

5.1.3 Server Option, System Variable, and Status Variable Reference

https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html

The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...

5.1.4 Server System Variable Reference

https://dev.mysql.com/doc/refman/5.7/en/server-system-variable-reference.html

The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...

13.1.18.5 FOREIGN KEY Constraints

https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html

MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...

13.7.5.37 SHOW TABLES Statement

https://dev.mysql.com/doc/refman/5.7/en/show-tables.html

Matching performed by the LIKE clause is dependent on the setting of the lower_case_table_names system variable. SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given database.