BarrMan
09-23-2007, 09:19 PM
Hey.
I'd like to create a table in an existing database but it doesn't seem to work.
I get this error when trying to execute the SQL statement:
Microsoft JET Database Engine (0x80040E14)
Syntax error in CREATE TABLE statement.
/system/installation.asp, line 188
This is how my statement looks like:
CREATE TABLE Insert table name (id INT NOT NULL AUTO_INCREMENT,test1 VARCHAR,test2, test3 VARCHAR, PRIMARY KEY id);
What am I doing wrong?
Thanks for the help!
I'd like to create a table in an existing database but it doesn't seem to work.
I get this error when trying to execute the SQL statement:
Microsoft JET Database Engine (0x80040E14)
Syntax error in CREATE TABLE statement.
/system/installation.asp, line 188
This is how my statement looks like:
CREATE TABLE Insert table name (id INT NOT NULL AUTO_INCREMENT,test1 VARCHAR,test2, test3 VARCHAR, PRIMARY KEY id);
What am I doing wrong?
Thanks for the help!