if you have a windows box that you can use as a front end, get a copy of corereader.
i recommend it to you because, among other things, it's a teaching tool. it allows you to do (genuine) point and click queries. you can do complex queries simply by clicking on selections. furthermore, you'll want to embed sql statements in your code. when you get a query that you like in corereader, you can open its sql statement to cut and paste. it will query any data source, and so far seems to like mysql particularly well. corereader is totally free from http://corereader.com/ . since it's for a non-profit organization, i'll correspond directly to help you get started. data connections can be frustrating. please respond directly to me to avoid cluttering this list. tell me what organization it is to insure that i am not opposed to its objectives. > Hello. > > I am starting a project that requires a simple database for use as a > back-end to a web-accessible look-up facility. When I say "simple" I > mean that the data is static and that the queries are done on single > keys. > > The catch is that I have zero experience in any kind of database work. I > have been doing software development for 20 years and am proficient in > several programming languages but have never had the occasion to do any > database programming. > > I've got some latitude as to what tools are use to achieve this > web-accessible database goal, so I'm going with Apache + MySQL in a Linux > (Red Hat 7.3) environment. (Cost is a high priority as this is being > done for a poverty-stricken non-profit.) I'm very familiar with Linux, > somewhat familiar with Apache (v1.3.x) and have no experience whatsoever > with MySQL. > > Would some kind soul(s) please suggest books and/or websites for the > MySQL newbie? I've perused the book list at www.mysql.com, but don't > have a feel for the experience level that these books are oriented > toward. > > Any pointers that you could provide to this beginner would be very > appreciated. > > Thank you. > > -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
