Hii all,
I have a project where before i upload the data from 1st database to 2nd database, im truncating the 2nd database and then trying to upload...
In this process, wat i found was that: My records in the database are something like:
`tbl_workers` (`wo_worker_id_pk` bigint(11) unsigned NOT NULL auto_increment,
`wo_worker_code` varchar(6) NOT NULL default '',
`wo_worker_catagory` varchar(50) default NULL,
PRIMARY KEY (`wo_worker_id_pk`),
UNIQUE KEY `wo_worker_code_idx` (`wo_worker_code`)
)
Is there any method to get the same index number for the primary key after i truncate and upload the records to the database..
For ex:
before truncating i find my database started with: 3000(wo_worker_id_pk)
ive got about 600 records
Now after truncating n uploading i find them starting with other number (3600)(wo_worker_id_pk)
so it is auto incrementing ......
I want them to start with 3000....
is there any way ....
plz help..
thnx.
hepsi...