If you need to install MySQL:
Installing MySQL on Windows
Dowonload the latest stable version of MySQL from the MySQL Download page or optionally you can start the download by clicking here.
To login to the MySQL server from the command line:
Go to the Start menu — > selct run.
Type dosprmpt in the input box to open up the command-line interface or if that doesn’t work try typing cmd in the input box. That should open up a dos like screen. Change your directory to the bin directory of MySQL by typing:
C:WINDOWSDesktop> cd c:mysqlbin
Remember to press enter after each command.
Now you can type mysql and press enter to start the MySQL monitor.
C:mysqlbin> mysql
You should see something like:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 4 to server version: 4.0.14
Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer.
Note: You may need to have winmysqladmin.exe running before you’re able to connect. You can start it by browsing to your C:mysqlbin directory and clicking on the winmysqladmin icon.
Getting Started with MySQL:
SELECT
To retrieve data from your database you use the Select key word. Try typing the following command at the mysql prompt:
mysql> select now();
You should see an organized table with the data you requested that looks something like this:
+———————+
| now() |
+———————+
| 2003-08-30 10:00:50 |
+———————+
1 row in set (0.00 sec)
Now() is an SQL function that returns the current date and time.
In MySQL keywords such as Select are not case sensitive. The following commands should have idnentical results:
mysql> SELECT VERSION();
mysql> select version();
In MySQL most commands need to have a semicolon at the end in order for it to be executed.
Try entering the follwoing command:
mysql> select current_date(),
You should see something like this:
mysql> select current_date()
->
If the command doesn’t have a semicolon at the end MySQL will move on to next the line with the -> prompt. This allows you to combine your commands on multiple lines which can be useful if you have a really long command.
To retrieve the info from the previous example simply type a semicolon at the -> prompt:
mysql> select current_date()
-> ;
+—————-+
| current_date() |
+—————-+
| 2003-08-30 |
+—————-+
1 row in set (0.00 sec)
You can also enter c to cancel your command and return to the mysql> prompt.
You can select multiple values with a single command by separating them with a comma:
mysql> select current_date(), version(), current_time();
+—————-+———–+—————-+
| current_date() | version() | current_time() |
+—————-+———–+—————-+
| 2003-08-30 | 3.23.54 | 11:48:43 |
+—————-+———–+—————-+
mysql> select current_date(),
-> version(),
-> current_time();
+—————-+———–+—————-+
| current_date() | version() | current_time() |
+—————-+———–+—————-+
| 2003-08-30 | 3.23.54 | 11:51:14 |
+—————-+———–+—————-+
1 row in set (0.00 sec)
Thanks.
