I need to be able to pull the column names which allow a NULL value, I know that
show columns from TABLE
Will give show me the table properties and whether or not the column allows null values, but is there a way to just return ONLY the columnnames which allow null.
show columns from TABLE where Null = 'YES'
doesn't work, but it explains what I need to accomplish.
And of course it's easy to just pull everything and sort it out later on, but if there IS a way to do what I'm asking, I'd like to learn it.