问题1:Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
解决:
a、是用navicat打开命令窗口(工具->控制台窗口)
b、查看配置,修改配置(注意:与Linux环境有所差异)
SELECT @@global.sql_mode; mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
备案号:湘ICP备19000029号
Copyright © 2018-2019 javaxl晓码阁 版权所有