查看mysql实例中哪些表字段可以为NULL/不可以为NULL

Leon_liuqinburen

于 2018-01-22 10:55:03 发布

阅读量578

点赞数

分类专栏： mysql 文章标签：字段为NULL

本文链接：https://blog.youkuaiyun.com/Leon_liuqinburen/article/details/79126577

版权

mysql 专栏收录该内容

4 篇文章

订阅专栏

 
 查看实例中哪些表字段可以为NULL 

select t1.table_schema,t1.table_name,t2.COLUMN_NAME from information_schema.tables t1, information_schema.columns t2   
where t1.table_schema = t2.TABLE_SCHEMA  and t1.table_name = t2.TABLE_NAME  and t2.IS_NULLABLE in( 'YES') 
and t1.TABLE_SCHEMA not in ('information_schema','performance_schema','test','mysql', 'sys');

 
 查看实例中哪些表字段不可以为NULL 

select t1.table_schema,t1.table_name,t2.COLUMN_NAME from information_schema.tables t1, information_schema.columns t2   
where t1.table_schema = t2.TABLE_SCHEMA  and t1.table_name = t2.TABLE_NAME  and t2.IS_NULLABLE in( 'NO') 
and t1.TABLE_SCHEMA not in ('information_schema','performance_schema','test','mysql', 'sys');