在MYSQL中复制表，一次不复制一行 [英] Duplicating table in MYSQL without copying one row at a time

问题描述

我想复制一个非常大的表，但我不想逐行复制它。有办法复制吗？

I want to duplicate a very large table, but I do not want to copy it row by row. Is there a way to duplicate it?

例如，您可以TRUNCATE w / o删除行/行，所以我想知道是否有类似的东西复制整个表

For example, you can TRUNCATE w/o deleting row/row, so i was wondering if there is something similar for copying entire tables

UPDATE：逐行插入是非常痛苦的（因为120M行）。 MySQL不再有可靠的复制表功能 - 这有很多原因与数据如何相关联，如何解决这个问题？为什么要避免这种情况呢？

UPDATE: row by row insert is very painful (because of 120M rows). Anyway to avoid that?

推荐答案

存储。但是，下面的行是逐行插入，但是很简单：

MySQL no longer has a reliable "copy table" functionality - many reasons for this related to how data is stored. However, the below does row-by-row insertion but is pretty simple:

CREATE TABLE `new_table` LIKE `old_table`;
INSERT INTO `new_table` (SELECT * FROM `old_table`);

这篇关于在MYSQL中复制表，一次不复制一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！