MySQL advanced references ???

[dgoosens]

Hi freaks,

 

I was wondering if any of you could point me to some kind of advanced reference guide about MySQL.

 

As you might be aware of, one has to do as much as possible of the data treatment within the MySQL-database as it is much faster and takes less resources than doing this within our PHP-scripts.

 

I have been looking in quite some places (Amazon, Eyeroles, SitePoint, etc. etc.) but I did not find any PHP/MySQL book that would go really further than the standard JOIN, and/or a couple of advanced techniques. It is for instance rare to find a book that explains the advantages for the PHP developer of using MySQL views...

 

I find it hard to believe that such a reference guide does not exist. There must be something else than http://dev.mysql.com/... Or not ?

 

Thanks in advance !

 

[Mchl]

http://oreilly.com/catalog/9780596003067

This seems to be widely recommended position. I've yet to put my hands on it.

[dgoosens]

thanks a lot Mchl.

I had a look at the book you suggested.

 

It does seem quite complete indeed... However, it is not really PHP/web oriented.

Although I am sure that this book would actually help me quite a lot, I am more looking for some kind of reference that is more PHP-specific...

 

Any other suggestions ?

[Mchl]

I'm not sure why would you want to learn 'PHP oriented MySQL'. There's not such a thing. Once you know how to use ext/mysql, ext/mysqli or PDO that's all you need to know.

The rest is pure MySQL.