Truncate or Delete tables from the MySql database

Question

I have a databse called store having 100 tables having too much foreign key references with tables, having thousands of records.

Problem: Is it possible something like truncate to delete all the rows of all the tables in a single query.

I tried but I am not able to find the exact way to achieve this when I try to TRUNCATE TABLE it gives me error: Cannot delete or update a parent row: a foreign key constraint fails which is expected too.

Can anyone please help me to achieve this, or suggest me the better way to do this.

If you want to delete all data you can simply recreate the DB. Delete the database and run the create script again. — juergen d
– juergen d, Commented Apr 17, 2013 at 13:11

Walid · Accepted Answer · 2013-04-17 14:40:34Z

1

Do this before deleting:

SET FOREIGN_KEY_CHECKS=0;

When finished, reset it to 1:

SET FOREIGN_KEY_CHECKS=1;

answered Apr 17, 2013 at 14:40

Walid

1,28211 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Truncate or Delete tables from the MySql database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related