msvcr70.dll was not found error when double click on desktop icon

I am a personal user who just downloaded the version 4.0 and mysql > administrator. The first time I clicked on the > "Administrator" icon > on my desktop I get an error that says "failed to start because > msvcr70.dll was not found. Try to reinstall. I did remove the > program a

ALTER TABLE z ADD INDEX... Speed: Follow up to LEFT JOIN question

What amount of time is reasonable to expect for indexing an FK int field on a simple table with about 30K records. It's running on my "learning" machine -- an aging Pentium 5/133 box running RH 8 which is ordinarily quite fast enough for my purposes. It's been running about six hours now, and

Re: LEFT JOIN help (or "come and slap the newbie")

a Soares On Tue, 2003-10-14 at 22:27, D. R. Hansen wrote: > Uberdumb question - but I'm still enough of a newbie that this is giving > me fits... > > I have four tables, with relevant columns as follows: > > ++ ++ > group zip >

LEFT JOIN help (or "come and slap the newbie")

Uberdumb question - but I'm still enough of a newbie that this is giving me fits... I have four tables, with relevant columns as follows: ++ ++ group zip -- -- name varchar city_id int zip mediumint zip mediumint