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

bye

Suresh

Options: ReplyQuote


Subject
Views
Written By
Posted
how to create a sequence
2885
July 07, 2005 06:56AM
1765
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.