How To Reset DB Tables After A Copy? 1

[3dColor]

I am creating a new site that is using the same tables from another DB.

Once I have copied the old tables over to the new site's DB is there a way to delete all the data and start the rows over at 1 instead of a high number where the old DB left off?

I basically want the structure of the database and reset to zero data.

Dave

 

[audiopro]

By start rows over, I assume you have auto increment rows in there.

DELETE FROM [TableName]

reset the increment count with

ALTER TABLE [TableName] AUTO_INCREMENT = 0

Keith

http://www.studiosoft.co.uk

 

[ingresman]

You might be best just copying over the structure of the tables rather than all the data and then deleting it all

 

[3dColor]

Would copying just the structure reset the auto increment rows to 0?

 

[ingresman]

I presume you want a new database with empty tables. Yes just creating the tables will set auto inc to 0.

 

[3dColor]

Cool, I will give that a try.

 

[towerbase]

TRUNCATE [TableName]

deletes all the data in [TableName] and sets the AUTO_INCREMENT value to zero and thus has the same effect as

DELETE FROM [TableName]
ALTER TABLE [TableName] AUTO_INCREMENT = 0

Needless to say you don't actually enter the [ and ] when using these statements.

Andrew
Hampshire, UK

 

[3dColor]

Thanks towerbase the TRUNCATE TABLE xx; command worked perfectly.