how to create a sequence
Posted by: Suresh N
Date: July 07, 2005 06:56AM

i'm not able to create a sequence in my MySQL 5.0 beta. If anybody knows, please send me with syntax with examples. Whether I have to any privileges to my schema in MySQL.

Like this error message I got from MySQL for the statement.

create sequence sample increment by 1 start with 1;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sequence seq start with 1 increment by 1' at line 1



Options: ReplyQuote

Written By
how to create a sequence
July 07, 2005 06:56AM
July 08, 2005 04:24PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.