Skip to content

Instantly share code, notes, and snippets.

@deivisonarthur

deivisonarthur/delete_all_customers.sql

Forked from michelbrito/delete_all_customers.sql
Created December 2, 2016 19:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save deivisonarthur/715f2e9484db9185cbb904b813c9d1b6 to your computer and use it in GitHub Desktop.
Save deivisonarthur/715f2e9484db9185cbb904b813c9d1b6 to your computer and use it in GitHub Desktop.
Download ZIP
Magento - Delete all customers
Raw
delete_all_customers.sql
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `customer_address_entity`;
TRUNCATE TABLE `customer_address_entity_datetime`;
TRUNCATE TABLE `customer_address_entity_decimal`;
TRUNCATE TABLE `customer_address_entity_int`;
TRUNCATE TABLE `customer_address_entity_text`;
TRUNCATE TABLE `customer_address_entity_varchar`;
TRUNCATE TABLE `customer_entity`;
TRUNCATE TABLE `customer_entity_datetime`;
TRUNCATE TABLE `customer_entity_decimal`;
TRUNCATE TABLE `customer_entity_int`;
TRUNCATE TABLE `customer_entity_text`;
TRUNCATE TABLE `customer_entity_varchar`;
SET FOREIGN_KEY_CHECKS = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment