New to MySQL...

[Anon]

Hello, I'm trying to dive into MYSQL and PHP. I'm wanting to eventually write a web application. I'm using Windows Platform right now for the ease of learning. I'm having trouble learning MYSQL though. I was hoping some of you could point me to some resources or recommend a book to help. I'm just worried about learning MYSQL Command Line for now, then later moving to the PHP. I was thinking I would be better off knowing MYSQL Command Line verses jumping right into both PHP and MYSQL. Do you think this makes much of a difference. Any help would be greatly appreciated.
Thanks for your time and efforts,
James M.

[knickerlas]

try www.mysql.com

always a good start and they've recently made it much more user friendly.

Nick

[[deleted]]

I guess you want to learn SQL rather than MySQL.

have a look at the manual on www.mysql.com.

Start by learning CREATE TABLE, DROP TABLE, ALTER TABLE.

Then start adding data using INSERT, and retreiveing data using SELECT.

These are the most important queries. Once you know these, you can start doing some complex things with them.

[Anon]

I found the "Building an E-Commerce Site" tutorials on www.devshed.com a really good introduction to both PHP and MySQL. You'll need some patience, but its worth it in the end.

Also, to administer MySQL, get PHPMyAdmin, which is available from http://phpwizard.net/projects/phpMyAdmin/

Its a browser based admin utility, for creating database, tables, etc. Easier then the command line.

[[deleted]]

phpmyadmin is a nice little utility for creating and manilulating the databases themselves, but it's useless for running comlex queries and has a very crappy backup-restore feature. Those things are best done through the mysql commandline.