mysql常用语句
1.查看某个库中哪些表存在对应的某个字段
select * from INFORMATION_SCHEMA.columns where COLUMN_NAME Like ‘%字段名%’ and table_schema = ‘库名’;
2.查看某个库中某个表中是否存在对应的某个字段
select * from INFORMATION_SCHEMA.columns where COLUMN_NAME Like ‘%字段名%’ and table_schema = ‘库名’ and table_name=‘表名’;
3.mysql8分组查询报1055错误
在/etc/my.cnf加上sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION’这行配置,重启数据库(数据库重启命令:service mysqld restart)