Technology Reviews

How to transparent a MySQL desk from all of the information?

To empty a MySQL table thru eliminating, that is, the entire data in it, you are able to use the DELETE command or the TRUNCATE. We see each and every the query:

DELETE FROM table_name;


TRUNCATE table_name;

This 2nd answer is faster than the principle one, why not make a cancellation, line thru line, then again deletes the table and recreates the an identical blank result is 0, the value of any fields auto_increment.

Continues after the economic…

Unnecessary to say, both one of the ones queries will have to be used with caution: the deletion of the entire data of a table, actually, is an irreversible operation, and previous to proceeding you have to make sure that you are going to have an entire backup of your data that you simply suppose you want to delete.

Browse content material subject material