I'm new to MySql......how do I?

[mds8000]

hello friends,
i'm new to MySql. just now installed. i thought it s a graphical IDE but it s a command line IDE. My question is how to

1.create
2.update
3.insert
4.delete
database's or table's in MySql? i know in MS SQL. also tell me how to use these commands in a php page. that is how to insert a value from the textbox to the DB................how to compare the values? ex: finding username when he enters his username and password...........
i think u got it.........pls help me...........

[Daemonspyre]

Although I always recommend CLIs over GUIs, try these tools:

1) http://dev.mysql.com/doc/refman/5.0/en/index.html -- The MySQL Manual. It's the place to learn all 4 of your questions

2) http://dev.mysql.com/downloads/gui-tools/5.0.html -- The MySQL GUI tools. Available for Mac, Windows, and *nix.

3) http://www.phpmyadmin.net/home_page/index.php -- One of the more popular GUI tools for MySQL.

As to populating databases from forms, that is more for the PHP or ASP forum, rather than the MySQL forum.

First, peruse the manual and download the tools. I think you will find that the rest will come easy to you.

HTH!

[guelphdad]

Read chapter 3 of the mysql manual, it is a tutorial on how to use mysql.

[StupidRalph]

There is nothing like good ole commands from the command line as it gives you a better understanding of whats going on under the hood. But, on occasions you may just want a quick an easy GUI. I prefer to use SQLyog (http://www.webyog.com).