"SQL command not properly ended" by creating a sequence

Question

 CREATE SEQUENCE seq_mitarbeiterid
    INCREMENT BY 1
    START WITH 0
    MAX VALUE 9999
    NOCACHE
    NOCYCLE;

I can't see what's wrong with that statement or why I get that error message.

Thanks in advance.

Look to me that CREATE SEQUENCE is a command that works in almost any database engine other than the one you tagged — RiggsFolly
– RiggsFolly, Commented Mar 26, 2017 at 11:24
@asparagus . . . As far as I know, MySQL does not support sequences. — Gordon Linoff
– Gordon Linoff, Commented Mar 26, 2017 at 11:48

Gurwinder Singh · Accepted Answer · 2017-03-26 11:22:11Z

1

From the error, it looks like you are using Oracle. If so, there is a syntax error near MAX VALUE - which should be MAXVALUE.

CREATE SEQUENCE seq_mitarbeiterid
INCREMENT BY 1
START WITH 0
MAXVALUE 9999    -- Here
NOCACHE
NOCYCLE;

answered Mar 26, 2017 at 11:22

Gurwinder Singh

39.7k6 gold badges62 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2017-03-26 11:49:27Z

0

As far as I know, MySQL does not support sequences. These are usually used to provide incremental ids for tables. If that is your purpose, then use auto_increment:

create table t (
    t_id int auto_increment primary key,
    . . .
);

answered Mar 26, 2017 at 11:49

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

"SQL command not properly ended" by creating a sequence

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related