ysql> insert into innodb_test (name) select name from innodb_test; Query OK, 1048576 rows affected (1 min 9.47 sec) Records: 1048576 Duplicates: 0 Warnings: 0
mysql> insert into memory_test (name) select name from memory_test; Query OK, 1048576 rows affected (6.45 sec) Records: 1048576 Duplicates: 0 Warnings: 0
10倍的速度差距
原文：https://www.cnblogs.com/youge-OneSQL/p/9514438.html