1. Delete:delete from table_name; or delete from table_name where column =?;
Delete the data in the table, but do not delete the table structure , delete the time is a row of deleted, less efficient, can be used to delete a single data.
2. Truncate:truncate from table_name;
deleting data in a table, without deleting the table structure , is more efficient than delete, and it uses fewer system and thing log resources.
The most important difference for delete and truncate is that after//delete deletes the data, it does not free up space and then adds data to the table, and the ID is still calculated from the last//data ID that was previously deleted//truncate after the data has been deleted. The space is completely released, and when you add data again, the ID starts at 1
3. drop:drop table table_name;
Delete the entire table structure and find the table again, then it does not exist .
The difference between delete,truncate,drop in MySQL