select version(), @@sql_mode;
执行:
SET sql_mode=(SELECT REPLACE(@@sql_mode,‘ONLY_FULL_GROUP_BY’, ‘’));
例如:
update borrow set comment =“ddddds”, commenttime=NOW() where bookid=1;
select version(), @@sql_mode;
执行:
SET sql_mode=(SELECT REPLACE(@@sql_mode,‘ONLY_FULL_GROUP_BY’, ‘’));
例如:
update borrow set comment =“ddddds”, commenttime=NOW() where bookid=1;