Best book to learn about MySQL from?

[N9ne]

I want a book, which goes from the basics to the advanced stuff.

Price isn't a problem...

I'd prefer a book from Wrox myself, as I have Beginning PHP4 from them, and it's excellent.

Please suggest and recommend books .

If possible, please specify as much detail as you can, ie. the full book name, company, etc. A link to amazon.co.uk or .com to buy it would also be great, so I can read reviews there too.

Thanks

[flup]

Just use the mySQL site or search for some tutorials,
for what I've seen it's quite easy!

Like:

$query = mysql_query("mysql SELECT * FROM database WHERE id='1'")

<?php
print $query
?>

On the place of * you are able to set a db table.
For example: name
If you have got a table in your database [wich is called "database" in this example] wich is called "name" it will display the "name" of the user with id "1"

It's actually very good to know mySQL for scripting with vB

[Dean C]

PPN (scott macvicar at .com) reccomended this book to me:

Mastering MYSQL4 - by Ian Gilfilan

- miSt

[N9ne]

Thanks for the reference Mist, and Flup, I know simple things like that, I was being specific enough in my post I believe :S

[flup]

No offence m8 :S

I'd prefer online manuals they are good enough

[Dean C]

Your Welcome

Trust me - refernce on the internet are complicated and unorganized - get a book

- miSt

[N9ne]

That's how I feel too, I had to learn some PHP from a book, I go to php.net regularly now for references on functions, and so on, but only for reference. I've made a few trips down to mysql.com too, for some general table queries I had. Books are the way to go to actually learn something though..