How do I get a list of all column names in a table that do not have NULL as their default value?
If I do "SHOW COLUMNS FROM table_name", I see there is a column in the results called "Default". I'd like my statement to return ONLY those columns that do not have NULL as the Default. I've tried using a WHERE clause, but I think it chokes because "Default" is a reserved word.
Thanks for any help!