title: Copying data from a table to archival tables based on column value MySQL
body: <p>I have a large MySQL table from which I want to copy data to 10 MyISAM archival tables based on a value of col (1 to 10). What is the most efficient way to do that? I guess simple <code>INSERT into arch1 (col1, col2, col3) SELECT col1, col2, col3 FROM tab WHERE col1=1</code> is too slow</p>