"John Berman" <[EMAIL PROTECTED]> wrote: > 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? >
Open "Register Server" window, go to MySQL Option. Here you can change value for the "Automatically limit SELECT queries to" option. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]