Learning MySQL

[Graham]

Hello, I am a person that has the desire to learn PHP and MySQL.[nbsp][nbsp]I have already dove into the world of PHP (still in the shallow end though) and I've heard about MySQL and that it has to do with Databases but I don't really know anything about MySQL.[nbsp][nbsp]Is there some place that can describe what MySQL does and how to use it and mabey an example? Or you could just tell me instead of giving me a URL :) But either will do.[nbsp][nbsp]Or is MySQL not really needed or not very useful unless you are like Extremly advanced and need to build a huge corporate website?

Thanks in advance for any information on the topic :)

[Brian]

I recomend you head over to Devshed : http://www.devshed.com

-Brian

[Shalazar]

If you're interested in learning more about MySQL, I suggest the following links:

http://www.mysql.com/Manual_chapter/manual_Tutorial.html#Tutorial
http://www.devshed.com/Server_Side/MySQL/
http://www.314interactive.com/wj/content.php3?id=pubs

The Geocrawler.com mailing list archives

And the MySQL book from PaulDubois.[nbsp][nbsp]Its an excellent reference.

That should get you up to speed on the virtues of the MySQL database![nbsp][nbsp]Best of luck.

[heath]

The new book by Paul Dubois is absolutely the best source of mySQL related information.[nbsp][nbsp]It makes the O'Reilly book look stupid, and has updated code snippets for using php, dbi,etc.[nbsp][nbsp]

I don't rave about many books, but this one is a **must** have for anyone using mySQL - I'd put it right up there with Phillip and Alex's Guide to Web Publishing and Mastering Regular Expressions and must reads for any web related endevor.

Heath

[Terra]

The new book by Paul Dubois is absolutely the best source of mySQL related information I agree totally, that is why it is required reading for all FutureQuest programmers.

Another good book about SQL theory is:
SQL for Smarties: Advanced SQL Programming (2nd Edition)
ISBN: 1-55860-576-2

It's also not MySQL specific, but nonetheless worth plowing through...[nbsp][nbsp]The only thing that it relies heavily on is sub-selects, which have to be worked around with MySQL...

And for the Perl realm, the new DBI book is turning into a must read:
Programming the Perl DBI
ISBN: 1-56592-699-4

90% of all my MySQL coding is done with Perl + DBI + DBD::mysql...[nbsp][nbsp]PHP3 doesn't really fit at the server core coding level... ;)

--
Terra
--I have a forest growing in my bookshelf--
FutureQuest
[This message has been edited by ccTech (edited 03-06-00@11:13 am)]