Dear all, It has become apparant of late that my ability to craft the most devious and awesome of MySQL statements is somewhat lacking. I have been using mysql for many years now in my php scripting, however I have never done much more than select, insert statements etc, and im pretty sure that what I need to learn how to do well are things like JOIN and more advanced database manipulation to make my querying as efficient as possible. My database design is none too shabby, I think it is just the method in which I pull data from it which needs some improvement. I was wondering if anybody knows any books or good websites that will help me make my querying more efficient? I use mysql alot and some of my works might become substancially quicker with the use of better queries Thanks! Bogo
Thoroughly recommended is "Sams Teach Yourself MySQL in 10 Minutes". Bought this book a year or so ago when I too wanted to delve deeper into MySQL syntax. I will say that now I've delved deeper it has in turn improved my PHP code. What may have taken lines and lines of PHP code with numerous MySQLi references can now be done in just one MySQLi reference and a few lines of PHP code. Not only is it a good book to get up to speed with further MySQL syntax it's also a handy size to keep on the desk for reference use which I find myself doing from time to time.
Have never used this specific book, but I have used some of Sam's other books - and they are great. I used sam's teach yourself tcp/ip in 24 hours book a couple of years ago, all of the informIT books are good I have a couple at home.
