Skip to content

Instantly share code, notes, and snippets.

@emtii

emtii/delete_customers_sw510.txt

Last active May 24, 2017 13:45
Show Gist options
  • Save emtii/3a74b41ebad4ee49fcb251a4e14441a3 to your computer and use it in GitHub Desktop.
Save emtii/3a74b41ebad4ee49fcb251a4e14441a3 to your computer and use it in GitHub Desktop.
Download ZIP
delete customers from sw5.1.0 instance
Raw
delete_customers_sw510.txt
1. truncate
====================================================================================================================
SET foreign_key_checks = 0;
TRUNCATE `s_user`;
TRUNCATE `s_user_attributes`;
TRUNCATE `s_user_billingaddress`;
TRUNCATE `s_user_billingaddress_attributes`;
TRUNCATE `s_user_debit`;
TRUNCATE `s_user_shippingaddress`;
TRUNCATE `s_user_shippingaddress_attributes`;
SET foreign_key_checks = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment