MySQL Install on OS X Leoperd

Hi There, Has anyone been successful installing and running MySQL (current version) on the new Mac OS (Leopard)? __ Craig Hoffman iChat/AIM: m0untaind0g __ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL Install on OS X Leoperd

they fix the pref pane. __ Craig Hoffman iChat/AIM: m0untaind0g __ On Oct 26, 2007, at 3:59 PM, Craig Hoffman wrote: Hi There, Has anyone been successful installing and running MySQL (current version) on the new Mac OS (Leopard

converting access (.mdb) files...

Anyone know a way to convert MS Access DB files (.mdb) into a format MySQL can import? I'm on a Mac hence I don't have Access. Best, CH ___ Craig Hoffman www.eclimb.net [EMAIL PROTECTED] iChat / AIM: m0untaind0g ___ -- MySQL General Mailing List

Re: Error - #1251

Thanks - I got it working. On Jan 18, 2005, at 12:35 AM, Mattias J wrote: At 2005-01-18 04:53, Craig Hoffman wrote: I upgrade to 4.1.9 last night and I keep getting this error in PhpMyAdmin after I changed the root password (yes I changed both pw's). Does anyone have a solution on how to fix

Like statement help

Hi There, I have web form where a user can search certain fields and then have them displayed aggregated. For example, find all the routes I climbed with partner A in area(s) ALL (% - wildcard) between date1 and date2 -- so on. See below for the complete query. I'm using pull down menu's and

Error - #1251

I upgrade to 4.1.9 last night and I keep getting this error in PhpMyAdmin after I changed the root password (yes I changed both pw's). Does anyone have a solution on how to fix this? I'm running a Mac 10.3.x #1251 - Client does not support authentication protocol requested by server;

Re: AVG Function

Mark, Yes its close and thank you. The problem I am having is I am able to generate the correct ranking.id for that particular user but I can't seem to make it equal the ranking.rating. ID ranking.rating 9 = 5.6 (example) Here's my query: SELECT routes.user_id, ranking.rating,

AVG Function

Hey Everyone, I can you some assistance on this query. I have three tables one is called ranking and the other is called routes and finally the users table. The users table is not really important. The ranking table looks like this: id rating 1 5.0 2 5.1 3 5.2 4 5.3

ORDER BY rand()

Hey Folks, I have a query where it pulls random data and display's it. SELECT route_photo, route, route_count, area FROM routes WHERE ORDER BY RAND() LIMIT 1 The query works fine, however, the route_photo field is partially populated. This results in just a route name appearing but no

Between Operator

Hey Everyone, I have query where one selects an style then a area and finally rating. When some selects a rating they select a range of ratings. For example: Style: Traditional Area: Yosemite Rating: From: 5.5 To: 5.10c This should pull up all the rock climbs that are in Yosemite, that are

Re: Between Operator

= 'Traditonal' GROUP BY route ORDER BY id DESC Thanks, Craig On Jul 9, 2004, at 1:17 PM, Pete Harlan wrote: On Fri, Jul 09, 2004 at 09:39:02AM -0500, Craig Hoffman wrote: Style: Traditional Area: Yosemite Rating: From: 5.5 To: 5.10c ... SELECT * FROM routes, users WHERE area='$area' AND style

Long numbers

TURNCATE(AVG(distance)), rest of the query Thanks - CH __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- MySQL General Mailing List For list archives: http

Re: Long numbers

that worked - Thanks a bunch! CH __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Apr 11, 2004, at 3:14 PM, Mike Blezien wrote: I think your looking for the ROUND(N,D

Truncating long numbers

. __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Truncating long numbers

Yes your right - I thought the numbers in the DB were something else. __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Apr 2, 2004, at 11:11 AM, Paul DuBois wrote