Getting an syntax error while creating table used sequence and nextval

Question

getting an syntax error in mysql

CREATE SEQUENCE users_id_seq;
CREATE TABLE users (
  id INTEGER PRIMARY KEY NOT NULL DEFAULT NEXTVAL ('users_id_seq'),
  name VARCHAR(50) NOT NULL,
  active BOOLEAN NOT NULL DEFAULT true,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

create a table with id sequence but getting syntax error

score 0 · Answer 1 · answered Dec 12 '22 at 02:28

The errors you're getting are due to the CREATE SEQUENCE statement, which is Oracle syntax for generating auto-incremental values.

In MySQL you can use the AUTO_INCREMENT keyword inside the table creation statement as follows:

CREATE TABLE users (
  id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
  name VARCHAR(50) NOT NULL,
  active BOOLEAN NOT NULL DEFAULT true,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

Check the demo here.

Getting an syntax error while creating table used sequence and nextval

1 Answers1