当前位置：网站首页>MySQL query error

MySQL query error

2022-07-19 10:43:00 【Xia'an code】

Expression #1 of ORDER BY clause is not in SELECT list, references column 'X1.t0.name' which is not in SELECT list; this is incompatible with DISTINCT

This is usually mysql Caused by version problems .

To settle temporarily ：

select version();
select @@global.sql_mode   Inquire about sql_mode
set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

Permanent solution ：
modify my.cnf, Get rid of ONLY_FULL_GROUP_BY Parameters :
add to sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

Errors are reported for queries with different character sets of database table fields , First, look at the... That created the table sql, Or look at the character set of table structure , Then modify it to be consistent ,

ALTER table table_name COLLATE=utf8mb4_general_ci, convert to CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

原网站

版权声明
本文为[Xia'an code]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/200/202207171254490832.html

边栏推荐

猜你喜欢

随机推荐