Check out safari.oreilly.com, they have a two week trial right now, and they have a sh*tload of books online, including 'MySQL Cookbook' by Paul Dubois, and they also have 'MySQL' and 'MySQL and Perl for the Web' by Paul also,
I would say they are probably the best MySQL books I've found, I also like Leon Atkinson, he's more a php man, but he's pretty good on SQL and he has a good book, Core MySQL, which isn't bad either and if you're into php any at all, he has a new book out Core PHP, which covers the upcoming php 5.0, but they do have the 2nd edition on line of this book, and he has a lot of good php/mysql code in it. I hate to keep pumping up Leon Atkinson, but he has an online shopping program called FreeTrade(open source), and if you study the code, you can find some interesting queries in it also... You'll have to google for the freetrade project, it moves around, and I'm not sure where it is now. I like both authors, they are both very good at explaining the material and they do get the point across very well. Kelley Randy Chrismon wrote: > Does anyone have a recommendation for a good SQL cookbook? I can do > some basic selects, updates and deletes but I'm not comfortable with > some of the logic involved in joins or the proper use of group by, > etc. In addition, though a full exposition on the SQL "language" > might > be instructive, right now, I need to figure out some queries. For > example, > > SELECT C_Date,InvoiceNum,AmtPaid FROM cash WHERE Office = "Denver"; > > Is very straight forward and returns what I expet. So does: > > SELECT SUM(AmtPaid) FROM cash WHERE Office="Denver"; > > But, is it possible to combine these two into a single statement so > that if I send it all to an outfile, I have a readable report? This > is > just an example of the kinds of things I'd like to be able to get a > handle on through some sort of reference. > > Thanks, > > Randy > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
