mysql报错：[Err] 29、[Err] 1290_CDA答疑社区

热线电话：13121318867

登录

liting李

2021-05-17 阅读量: 1018

mysql报错：[Err] 29、[Err] 1290

[Err] 29

解决方案：将需要导入文件路径放在mysql安装路径下

[Err] 1290

解决方案：在my.ini文件 [mysqld]节点下添加secure_file_priv=’’，重启mysql服务

[Err] 1140 - In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column ‘练习.item_score.itemid’; this is incompatible with sql_mode=only_full_group_by

解决方案：在语句前添加

set sql_mode = ‘’;

set sql_mode = ‘NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES’;

90.0000

1

0

关注作者

收藏

评论(0)

发表评论

暂无数据

CDA考试动态

CDA报考指南

推荐帖子