MySQL: "DROP TABLE" completely deletes a table or just a structure?

Question

My impression is that the MySQL command DROP TABLE Userwill simply delete the data, columns, and associated restrictions. However, the table wrapper still exists. Is it correct?

Answer 1

Use DROP TABLEwill delete the entire table and all records contained within it. If you want to keep the table structure but delete all the data, consider using it TRUNCATE TABLE. Truncating a table is done by deleting the entire table and then recreating it. This is faster than execution DELETE FROM yourTable, which deletes records one by one.

Answer 2

Drop Table , ( " " ); TRUNCATE TABLE , reset auto-increment , TRUNCATE, , .

Answer 3

mysql drop table :

! .

, ( ) .

Answer 4

?

MqSQL:

DROP TABLE . DROP .

Be careful with this statement! It deletes the table definition and all table data. For a partitioned table, it permanently deletes the table definition, all its partitions, and all data stored in these partitions. It also removes the partition definitions associated with the dropped table.