SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:01 AM
| ||||
| ||||
 sequential numbering in Auto_Increment Field across two tables 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.      |
Linear Mode
