Hello, What's the proper way to delete user records from the table Customers (with all the related tables data). for one i have deleted records in the db with deleted= 1 that would not allow me to use those emails again and also i have lot of spam users in db which is nice to get rid to keep records clean.
I use Microsoft Access to open the database - with ODBC Connection It’s easy to see the data and delete customer records
The deleted = true customers are easy - just sort / filter and delete. Other than that you need some criteria and a way to know they are spam - not just customers who have not purchased yet.
One criteria might be delete customers older than 2 months who do not have any paid orders.
You can also use MQL Management Studio to write a query to delete (There are probably other tools)
Alternatively you can customise some code to do the above.
Hi Yidna, Thank you for the reply. Yes i understand it's important to be careful what customers not to delete and i do use sql management studio. But my questions was just want to know the correct query to delete the user and it's existing records from all the other table too. I mean i can just delete the customer just from that table but i'm pretty sure that user records from "Customer" table data might have a relationship to other tables.
Did you get an answer on this? I'm having the reverse issue. Trying to import customer data from another system and we're still missing a relationship somewhere. Not certain to which table though.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Hâlen sorularınız mı var veya yardıma mı ihtiyacınız var?