MySQL database name and table name cannot be capitalized

Lower_case_table_names parameter Details:

Where 0: Case sensitive, 1: Case insensitive

MySQL under Linux database name, table name, column name, alias casing rules are like this:

1, database name and table name are strictly case-sensitive;

2, the table alias is strictly case-sensitive;

3, the column name and the alias of the column in all cases are ignored case;

4, variable names are also strictly case-sensitive;

MySQL is case insensitive under Windows.

3, if you want to distinguish the case of the field value when querying, then: The field value needs to set the binary property, there are several ways to set it:

A. Set at creation time:

CREATE TABLE T (

A VARCHAR (Ten) BINARY

);

B. Modify with Alter:

ALTER TABLE ' tablename ' MODIFY COLUMN ' cloname ' VARCHAR BINARY;

C, the MySQL tableeditor directly tick binary items.

MySQL database name and table name cannot be capitalized