Re: Why do I keep getting Error 1604(42000)?

[kumbamamfe]

Thanks, Vangelis.

I've also tried to use the Query Browser. Here is an example
of code and the resulting error. I already suspect that it has to
do with creating 2 tables. If so, how do I write code to create,
for example, 100 tables at once in a database? Obviously, it will
take forever if I have to create them one by one.

Thanks in advance.

------------------------------------------------------------

CREATE TABLE badFormSubmission (
ip VARCHAR(15) NULL,
browser VARCHAR(200) NULL,
referrer VARCHAR(250) NULL,
submissionDate DATETIME NOT NULL,
formTemplate VARCHAR(20) NOT NULL,
formContent VARCHAR(1200) NULL
);
CREATE TABLE contact (
msg_ID CHAR(16) NOT NULL,
client_ID CHAR(16) NOT NULL,
replyEmail VARCHAR(100) NULL,
contactTel VARCHAR(20) NULL,
subject VARCHAR(50) NULL,
message VARCHAR(1050) NULL,
messageLength INT(10) NULL,
ip VARCHAR(15) NULL,
browser VARCHAR(200) NULL,
referrer VARCHAR(250) NULL,
contactDate DATETIME NOT NULL,
PRIMARY KEY (msg_ID)
);

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE contact (
msg_ID CHAR(16) NOT NULL,
client_ID CHAR(16) NOT' at line 8