I kinda wondered how long it would take...
mysql> insert into foo_new select * from foo; Query OK, 60000000 rows affected (3 hours 3 min 52.94 sec) Records: 60000000 Duplicates: 0 Warnings: 0
Posted by jzawodn at April 01, 2004 04:13 PM
Disclaimer: The opinions expressed here are mine and mine alone. My current, past, or previous employers are not responsible for what I write here, the comments left by others, or the photos I may share. If you have questions, please contact me. Also, I am not a journalist or reporter. Don't "pitch" me.
Privacy: I do not share or publish the email addresses or IP addresses of anyone posting a comment here without consent. However, I do reserve the right to remove comments that are spammy, off-topic, or otherwise unsuitable based on my comment policy. In a few cases, I may leave spammy comments but remove any URLs they contain.