DB conversion

[Matthew Rice]

"Lance F. Squire" <lance-5ZoueyuiTZhBDgjK7y7TUQ at public.gmane.org> writes:
> Specificly, is there a MySql equiv. for:
> 
> CREATE SEQUENCE "data_ref_seq" start 1 increment 1 maxvalue 2147483647
> minvalue$SELECT nextval ('"data_ref_seq"');

You probably want to look at the AUTO_INCREMENT keyword:

        http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html

HTH,
-- 
matthew rice <matt-s/rLXaiAEBtBDgjK7y7TUQ at public.gmane.org>                               starnix inc.
phone: 905-771-0017 x242                        thornhill, ontario, canada
http://www.starnix.com              professional linux services & products
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml