How to use CREATE SEQUENCE in MySQL

[kudinesh]

how to create a sequence menttioned below..for number generators.

CREATE SEQUENCE  sequ
  START WITH 1
  INCREMENT BY 1

[Atli]

Hi, and welcome to TSDN!

The 'CREATE SEQUENCE' syntax does not work in MySQL.
I looked around a bit and found it in a MaxDB reference manual.

[pbmods]

Heya, kudinesh.

MySQL numeric primary keys can be given an auto_increment property that may be what you're looking for:

CREATE TABLE
    `counter`
    (
        `key` int(10) unsigned not null auto_increment primary key
    );
 

[prasadshaha93]

how to create a sequence menttioned below..for number generators.


CREATE SEQUENCE sequ
START WITH 1
INCREMENT BY 1

i do this but i hav syntax error , i am using SQLYOG mysql GUI
so plz give me idea

solve my problem

Thanking You ,

[pbmods]

Heya, prasadshaha93. Welcome to TSDN!

Try reading the other posts in this thread.