Hi,
I have tried searching the forum for an answer, but have been unable to find one. I received this error while trying to create a test table.
--------
MySQL said: You have an error in your SQL syntax near '(15) BINARY NOT NULL DEFAULT 'FirstName' ,ID INT(10) BINARY NOT NULL AUTO_INCREM' at line 1.
Query: CREATE TABLE test(First TEXT(15) BINARY NOT NULL DEFAULT 'FirstName' ,ID INT(10) BINARY NOT NULL AUTO_INCREMENT)
--------
Any help would be appreciated. Thank you.
Robert Blackstone
Webmaster of Scato Search
http://www.scato.com
I have tried searching the forum for an answer, but have been unable to find one. I received this error while trying to create a test table.
--------
MySQL said: You have an error in your SQL syntax near '(15) BINARY NOT NULL DEFAULT 'FirstName' ,ID INT(10) BINARY NOT NULL AUTO_INCREM' at line 1.
Query: CREATE TABLE test(First TEXT(15) BINARY NOT NULL DEFAULT 'FirstName' ,ID INT(10) BINARY NOT NULL AUTO_INCREMENT)
--------
Any help would be appreciated. Thank you.
Robert Blackstone
Webmaster of Scato Search
http://www.scato.com