Emptying Customers & Orders from database

[mark27uk3]

Hi Guys,

 

Just a quick one (hopefully)!

 

Can anyone tell me the sql for emptying the data from the customers and orders fields in the database please.

 

It will save me hours going through and clicking delete on each one twice.

 

Thanks

 

Mark :thumbsup:

[keoga]

Hi Guys,

 

Just a quick one (hopefully)!

 

Can anyone tell me the sql for emptying the data from the customers and orders fields in the database please.

 

It will save me hours going through and clicking delete on each one twice.

 

Thanks

 

Mark :thumbsup:

<{POST_SNAPBACK}>

 

Backup your database first:

 

1. mysqldump -u youruser -p youropassword databasename > databasename.sql

 

2. in mysql prompt: delete from customer; delete from orders;

 

3. Great tutorial site: http://www.webdevelopersnotes.com/tutorials/sql/index.php3

 

 

Cheers kenneth ;)

[peterr]

Hi,

 

Backup your database first:

 

1. mysqldump -u youruser -p youropassword databasename > databasename.sql

 

2. in mysql prompt:  delete from  customer; delete from orders;

 

3. Great tutorial site: http://www.webdevelopersnotes.com/tutorials/sql/index.php3

Cheers kenneth ;)

<{POST_SNAPBACK}>

 

You will get yourself into a lot of trouble if all you do for removing the appropriate rows, is step 2, it is definitely a lot more involved than that. I've had to convert numerous carts to osCommerce, and 'customers' alone is 3 tables, customers, customers_info and address_book. The same is true for orders, there are a number of tables involved.

 

Peter