Re: IS NOT NULL

[Peter Brawley]

SHOW is sometimes convenient, but it's archaic and its syntax is non-standard and arbitrary. Rather than waste time trying to divine how to make SHOW behave as if it were SELECT, consider using information_schema, eg for a table named 'tbl' in the current DB ...

select column_name
from information_schema.columns
where table_schema=database() and table_name='tbl' and column_default is NULL;