On Mon, 27 Oct 2003 15:24:37 -0500, Priyanka Gupta <[EMAIL PROTECTED]> wrote:

Is there a way in mYSQL to just define an auto increment sequence rather than defining 
a field inside a table which is an auto increment. Bsically I need some functionality 
similarto that in ORACLE where CREATE SEQUENCE seq INCREMENT BY 1 START WITH 1 
MINVALUE 1;
basically creates a seq that increments by one each time....

No. Obviously, you can achieve the same result by creating a table with one auto_increment column set to the specifications you need, but MySQL does not have an exact corrolary to Oracle's sequence.

-bluejack


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to