-- 1.获取删除MySQL数据库表注释脚本
select
concat('ALTER TABLE ',table_name," COMMENT = '';")
fROM information_schema.TABLES
where table_type='BASE TABLE' and TABLE_SCHEMA='填写数据库名称';
-- 2.将获取的sql执行即可
-- 获取删除MySQL数据库表字段注释脚本
SELECT
concat('alter table ', table_schema, '.',table_name,
group_concat(
'\n','modify column ',column_name,
' ' ,column_type,
' ' ,if(CHARACTER_SET_NAME is null ,'',concat('CHARACTER SET ',CHARACTER_SET_NAME)),
' ' ,if(COLLATION_NAME is null ,'',concat('COLLATE ',COLLATION_NAME)),
' ' ,IF (is_nullable = 'YES',IF(data_type IN ('timestamp'),' null',''),'not null'),
' ' ,IF (column_default IS NULL,'',