Re: How to update MySQL table based on 3 other tables

2013-09-03 Thread shawn green
Hello Neil, On 8/24/2013 5:21 AM, Neil Tompkins wrote: I have the following four MySQL tables Region RegionId City CityId RegionId Hotel HotelId CityId HotelRegion HotelId RegionId I'm struggling to write a UPDATE statement to update the City table's RegionId field from data in the HotelReg

Re: Can't Connect Localhost

2013-09-03 Thread hsv
2013/09/02 12:49 +0800, John Smith > > I looked in mysql.config.pl and no "localhost" :( > "mysql.config.pl" from what software damned? > "mysql.config.pl" does not exist in context of mysql It exists in the following folder on my Win8 box: /Program Files (x86)/MySQL/MySQL Server 5.5/bi

Re: Can't Connect Localhost

2013-09-03 Thread shawn green
Hello John, On 9/2/2013 12:49 AM, John Smith wrote: On Sun, 1/9/13, Reindl Harald wrote: Subject: Re: Can't Connect Localhost To: mysql@lists.mysql.com Date: Sunday, 1 September, 2013, 2:44 PM I looked in mysql.config.pl and no "localhost" :