Depends on how your table is designed. You could do an 'INSERT INTO .. SELECT FROM ..' with a WHERE/ORDER BY/LIMIT combo (switch the ORDER BY for each new table). It would be probably easiest if you have an AUTO_INCREMENT field..
Atle - Flying Crocodile Inc, Unix Systems Administrator On Tue, 12 Jul 2005, Brian Dunning wrote: > If I have a table with 200K records, is there an easy way to split it > into two separate tables with 100K records each? > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]