IS NOT NULL
I have been using SQL Server for MANY, MANY years. I am new to MySQL and I have a very simple query that is not working:
show full columns in table_name
where default IS NOT NULL
The error is a syntax error near 'IS NOT NULL'. I also tried putting brackets around default thinking that it may be a reserverd word. Can someone tell me what the proper syntax should be?
Subject
Written By
Posted
IS NOT NULL
March 21, 2013 09:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.