Re: Migration of a database from mSQL 2.x to MySQL 3.23.51

2002-06-21 Thread Joseph Bueno
Hi, Mark Hennessy wrote: > I have decided to use MAX(tablename_index)+1 in advance of inserting the > record, as I want to use as little dbms-specific magic as possible and > this matches as close as I can figure the behavior of _seq in mSQL. > > I would be doing the following in the same thread

Re: Migration of a database from mSQL 2.x to MySQL 3.23.51

2002-06-21 Thread Mark Hennessy
: Mark Hennessy <[EMAIL PROTECTED]> > To: Gerald Clark <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Migration of a database from mSQL 2.x to MySQL 3.23.51 > > I don't see how AUTO_INCREMENT preserves its value in the output of a &