数据库相关问题

适用版本：所有版本;

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