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]