SELECT CONCAT('alter table ',table_name,' ALTER COLUMN ',column_name,' SET DEFAULT NULL;') as col ,TABLE_NAME,COLUMN_NAME,DATA_TYPEFROM INFORMATION_SCHEMA.columns aWHERETABLE_SCHEMA='TEST' -- 代表所在的数据库