This article explains the use and difference of delete, truncate and drop statements of mysql.1. delete : delete command is used to delete all or specific records from mysql table. the records delete ...

DROP comes under DDL (Data Definition Language). It removes whole table (including table structure) from the database. The data cannot be roll backed if the table is dropped by 'DROP' command. Syntax: ...

recycle_bin并不直接作用于master，而是工作在主从环境中的从机上，当通过程序或者人为在master上进行drop table操作时，slave会拦截drop操作， 先进行数据备份，再进行删除操作。 当备份文件超过保存时间后，recycle_bin会自动清除这些备份数据。 欢迎加入MySQL内核交流群 ...