如何恢复被截断的表 [英] How to restore a truncated table

问题描述

如何恢复被截断的表的数据?

How do I restore the data of a truncated table?

推荐答案

截断操作删除并重新创建表，这比逐行删除要快得多，特别是对于大表.

Truncate operations drop and re-create the table, which is much faster than deleting rows one by one, particularly for large tables.

http://dev.mysql.com/doc/refman/5.0/en/truncate-table.html

您可以从备份中恢复表，如果有的话

You can restore a table from a backup, if it was

这篇关于如何恢复被截断的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！