when trying to create a table with this line in the create statement
Id INT NOT NULL AUTO_INCREMENT,
I get a syntax error for the AUTO_INCREMENT.
same when trying to put 1 in auto increment field in options tab.
any idea why? how to overcome that?
thanks in advance