Removing Clients from Magento database

11.12.2013 Angelika Siczek

After tests are finished, it is good to clean database with any unnecessary accounts. Below commands should remove unliked writings from the customer’s charts.

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`;

Have a question?

Write to us

Name*

Last Name*

Email*

Phone number*

Company*

I would like to sign a non-disclosure agreement (NDA)

Would you like to share some files?✕

PDF, DOC, DOCX, JPG lub PNG (max 5MB)

Message

I accept receiving marketing content by e-mail from Global4Net Sp. z o.o based in Wrocław. I am aware that I can unsubscribe at any time. More information about the processing of my data is available in the privacy policy.

Completing and sending the message with your personal data constitutes a response to your personal data by Global4Net Sp. z o.o based in Wrocław, to answer your question or inquiry. Sending a message is confirmation that you are aware that you have the opportunity to withdraw consent at any time. Additional information about the processing of available data is provided in the privacy policy.*

I want to receive marketing communication by phone from Global4Net Sp. z o.o based in Wrocław. I am aware that I can unsubscribe at any time. More information about the processing of my data is available in the privacy policy.

*Required