1
create table t1 (a int primary key);
2
insert into t1 values ();
3
ERROR HY000: Field 'a' doesn't have a default value
4
select COLUMN_NAME,COLUMN_DEFAULT,COLUMN_DEFAULT_IS_NULL FROM DATA_DICTIONARY.COLUMNS WHERE TABLE_SCHEMA="test" AND TABLE_NAME="t1";
5
COLUMN_NAME COLUMN_DEFAULT COLUMN_DEFAULT_IS_NULL