jdbc error creating table

Question

Possible Duplicate:
Create autoincrement key in Java DB using NetBeans IDE

I am trying to create a table in netbeans, using -

CREATE TABLE Persons (
    P_Id int NOT NULL AUTO_INCREMENT,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255),
    PRIMARY KEY (P_Id)
)

but am getting the following error -

Syntax error: Encountered "AUTO_INCREMENT" at line 3, column 19. Line 1, column 1

Using Netbeans 7.2 and Mysql database I have no problem running your query. What database are you connected to? — JScoobyCed, Nov 23 '12 at 02:48
I am using Netbeans 7.2 adn mysql database too. But. i get an error when i execute the sql command — SimplyJaymin, Nov 23 '12 at 02:54
@ user997478 : Please check http://stackoverflow.com/questions/3308329/create-autoincrement-key-in-java-db-using-netbeans-ide — Jayan, Nov 23 '12 at 03:06
If you get a syntax error, why not just look up the right syntax in the [reference manual](http://db.apache.org/derby/docs/10.9/ref/)? — Mark Rotteveel, Nov 23 '12 at 10:29

score 1 · Answer 1 · answered Nov 23 '12 at 03:31

Try removing the underscore. I think you can also combine the primary key declaration with the column like the following:

CREATE TABLE Persons (
    P_Id integer primary key autoincrement,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
)

jdbc error creating table

1 Answers1