hello, I have mysql version 4.0.16. I am trying to create a sequence to use for a customer_id field. Anyway I try this ...
CREATE SEQUENCE "new_num" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1; or just CREATE SEQUENCE "new_num"; and both give me a sytax error. What am I doing wrong? Thanks, -- jdavis <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]