I'm getting a MySql syntax error. ?

Question

I need to declare some fields in my Mysql data base to be of type integer and they should have default value null. But declaring like this is showing syntax error. What is the alternative??

Answer 1

try this syntax

CREATE TABLE test

    (test1                          VARCHAR2(11) DEFAULT 'yes' NOT NULL)

/

Answer 2

Paste the SQL querry so we can check where the error is.