Re: Is there an update limit

2004-03-14 Thread Victoria Reznichenko
"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

Is there an update limit

2004-03-13 Thread John Berman
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 I