Hello
All,
I am trying to
create a table whose primary key AutoIncrements. Creating the table is not a
problem, making the primary key auto increment is.
Here is the
query.
-------------------------
<cfquery name="create_table"
datasource="xx_renters">
CREATE TABLE user
(
user_id INTEGER NOT NULL PRIMARY KEY,
user_name VARCHAR (20) NOT NULL,
password VARCHAR (20) NOT NULL,
UNIQUE (user_id)
)
</cfquery>
user_id INTEGER NOT NULL PRIMARY KEY,
user_name VARCHAR (20) NOT NULL,
password VARCHAR (20) NOT NULL,
UNIQUE (user_id)
)
</cfquery>
------------------------
I have tried all
means of syntax for autoincrement but with no luck.
Thanks for any
advice.
Best,
Erik
