Quote: refer to the third floor f the wind long reply:

Quote: refer to the second floor leaves heavy Yang response:

by lower_case_table_names parameters change whether or not they were case sensitive,

Change the database parameter files. My CNF
Under the mysqld to add or modify lower_case_table_names=1
After the restart the database

Lower_case_table_names=1 table name is stored in the disk is small, but the comparison is not case-sensitive
Under Windows default value is 1, the need to modify,

Source: https://blog.csdn.net/wangkun_j/article/details/82190815

Sensitivity changed, but the table name initials or cannot achieve capitalization

You mean set lower_case_table_names=0 are case sensitive, and then create a new table such as the Test list, you can see the Test table name is not capitalized the first letter in T?

Yes, find a bad method with...

CodePudding user response:

I tried it on, under the Windows Settings lower_case_table_names=0, service start direct error!!!!!!

Saw a solution: https://blog.csdn.net/ceciliawanghenan/article/details/82916662
But want to empty my data, don't monkey around,

And saw a post: https://bbs.csdn.net/topics/391947116
It this way: Windows set to 0 lead to damage of MySQL MyISAM, or don't take such a risk,

My day, have what demand, why must be table to capitalize the first letter

CodePudding user response:

reference 5 floor leaves heavy Yang reply:

Quote: refer to the third floor f the wind long reply:

Quote: refer to the second floor leaves heavy Yang response:

by lower_case_table_names parameters change whether or not they were case sensitive,

Change the database parameter files. My CNF
Under the mysqld to add or modify lower_case_table_names=1
After the restart the database

Lower_case_table_names=1 table name is stored in the disk is small, but the comparison is not case-sensitive
Under Windows default value is 1, the need to modify,

Source: https://blog.csdn.net/wangkun_j/article/details/82190815

Sensitivity changed, but the table name initials or cannot achieve capitalization

You mean set lower_case_table_names=0 are case sensitive, and then create a new table such as the Test list, you can see the Test table name is not capitalized the first letter in T?

For and establish course selection table with foreign key link no matching column names would appear

CodePudding user response:

refer to the eighth floor leaves heavy Yang response:

I tried once, set up under the window lower_case_table_names=0, service launched direct error!!!!!!

Saw a solution: https://blog.csdn.net/ceciliawanghenan/article/details/82916662
But want to empty my data, don't monkey around,

And saw a post: https://bbs.csdn.net/topics/391947116
It this way: Windows set to 0 lead to damage of MySQL MyISAM, or don't take such a risk,

My day, have what demand, why must watch capitalize the first letter?

Well, just want to try, MySQL under Windows system for the definition of the table name is too fuzzy