MySQL Forums
Forum List  »  Newbie

IS NOT NULL
Posted by: Cathy Baker
Date: March 21, 2013 09:08AM

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?

Options: ReplyQuote


Subject
Written By
Posted
IS NOT NULL
March 21, 2013 09:08AM
March 21, 2013 11:09AM
March 21, 2013 11:55AM
March 21, 2013 08:54PM
March 22, 2013 10:19AM


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.