auto_increment command for SQL is not working

Question

CREATE TABLE tbl_user(
  user_id BIGINT not NULL AUTO_INCREMENT,
  user_name VARCHAR(45) NULL,
  user_username VARCHAR(45) NULL,
  user_password VARCHAR(45) NULL,
  PRIMARY KEY (user_id)
  );

Ι keep getting an error that says

"An unexpected token "," was found following "Y KEY AUTO_INCREMENT". Expected tokens may include: "". SQLSTATE=42601"

user_id INTEGER GENERATED ALWAYS AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 20 NO ORDER ), — Esperento57, Apr 25 '17 at 15:19

score 0 · Answer 1 · answered Apr 15 '17 at 06:49

0

you can use IDENTITY(1,1) for that as:

CREATE TABLE tbl_user(
  user_id BIGINT IDENTITY(1,1) not NULL,
  user_name VARCHAR(45) NULL,
  user_username VARCHAR(45) NULL,
  user_password VARCHAR(45) NULL,
  PRIMARY KEY (user_id)
);

or also you can set it using designer.

answered Apr 15 '17 at 06:49

kritikaTalwar

1,730
1
17
25

1

***IF*** you're using Microsoft **SQL Server** - yes - but not for other systems. Since the OP didn't say **what** RDBMS he's using, this is very unsure to be an exact match ..... – marc_s Apr 15 '17 at 06:59
I'm still getting an error that says "An unexpected token "IDENTITY" was found following "USER( user_id BIGINT". Expected tokens may include: "DEFAULT". SQLSTATE=42601" – Joojo Dontoh Apr 15 '17 at 07:00
which RDBMS are you using? @JoojoDontoh – kritikaTalwar Apr 15 '17 at 07:03
@marc_s you are absolutely right – kritikaTalwar Apr 15 '17 at 07:04
ibm db2 express-c – Joojo Dontoh Apr 15 '17 at 07:05
may be this will give you an idea >http://stackoverflow.com/questions/13466347/how-to-auto-increment-in-db2 – kritikaTalwar Apr 15 '17 at 07:07

auto_increment command for SQL is not working

1 Answers1