 | | | -none- | -none- 2007-10-11 - By Stephen Sunderlin
Back
I have two tables.
TableA is current data.
TableB (created with 'Create Table A like Table B' ) is an archive where
deleted data is inserted from Table A before being deleted from table B with
"INSERT INTO TableA Select * , Null, NOW (), 'ACTION', 'USER' from TableA.
The null column in TableB is a primary, Not Null AUTO_INCREMENT field.
The issue is that the first auto increment number in the primary key of
TableA is the next highest value of the AUTO_INCREMENT field of tableA
instead of what I would have suspected was "1". Is this normal. Does it
matter. And will this create conflict with other quires using
LAST_INSERT_ID() Function?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|