作者:Eddy  历史版本:1  最后编辑:龚清  更新时间:2024-05-28 11:17

适用版本:所有版本;

oracle里插入空字符串会被转成null插入

会造成某些不可知的异常

MySQLSyntaxErrorException: Can’t find any matching row in the user table

  • 原语句grant select,insert,update,delete,create on ibps_saas_dev_csy_ibps_business_provider.* to root;
  • 修改为grant select,insert,update,delete,create on ibps_saas_dev_csy_ibps_business_provider.* to root identified by '你的密码';

解决[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

  • my.cnf或my.ini文件添加sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION