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

It means that you have incorrectly formatted/configured the field above or below your FirstName field.

Regards,

Eliot Lee

Hi Eliot,

Thank you for your reply :)

Robert Blackstone
Webmaster of Scato Search
http://www.scato.com

You're welcome.

Regards,

Eliot