1. Table name case sensitive, Linux down to MySQL:
- Database name and table name are strictly case-sensitive;
- Table aliases are strictly case-sensitive;
- The alias of the column name and column is ignored in all cases;
- Variable names are also strictly case-sensitive.
Modify the method: Modify the Mysqld.cnf file, add Lower_case_table_names=1 in the Mysqld configuration section, and restart the MySQL service (you can see if the modification was successful by show ariables like ' lower% ')
2.select Statement 1055 error, Reason: For group by aggregation operation, if the column in select does not appear in group BY, then this SQL statement is illegal
Modify method: First query select @ @sql_mode; Remove only_full_group_by, modify mysqld.cnf file, add or modify MYSQLD configuration section to Sql_mode item to remove
3. Code execution SQL statement after inserting Chinese text field garbled
Modify the method: Modify the Mysqld.cnf file, mysqld configuration section add Character_set_server=utf8; (the default is Latin1, you can variables like ' character% ' by show View current status)
MySQL migrating to Ubuntu encounters a problem