MySQL5.6导入MySQL5.7报错解决办法

select @@global.sql_mode

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

set @@global.sql_mode ="STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";

posted @ 2021-01-18 21:31  雷雨客  阅读(703)  评论(0编辑  收藏  举报