Consult the SQL query list all column value is not null columns have? How do you write this statement
Table is the main table, column

CodePudding user response:

The SELECT tc olumn_name, t.i s_nullable FROM information_schema. Columns t WHERE t.t able_schema=SCHEMA () AND t.t able_name=name of the table;
Column_name field name, is_nullable, NO is not empty, YES can be null,