Re: Is this wise use of auto_increment?

2005-04-05 Thread SGreen
Julian Pellico <[EMAIL PROTECTED]> wrote on 04/04/2005 06:38:57 PM: > Hello, > > I'm using MyISAM tables in mysql and in order to make a certain > operation appear atomic, I need to insert records into 2 tables in a > certain order. In particular, in one of the tables is a key that maps > to mult

Is this wise use of auto_increment?

2005-04-04 Thread Julian Pellico
Hello, I'm using MyISAM tables in mysql and in order to make a certain operation appear atomic, I need to insert records into 2 tables in a certain order. In particular, in one of the tables is a key that maps to multiple rows in the other table. This is the sane thing to do if there were'nt any o