Hi Using MYSql 4.x
I'm trying to execute the following in MySQL Control Center INSERT INTO jgsurname_index ( type, surname ) SELECT mc_JewishChronicle.type, mc_JewishChronicle.SURNAME FROM mc_JewishChronicle; It works fine but only does 1000 rows, the mc_JewishChronicle table has 25,000 rows Is it something obvious that I'm missing? Regards John Berman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]