- Impact
- 6
Code:
//
//
//Tutorial by deadserious - © [url]http://www.webdesigntalk.net[/url]
//© 2003 [url]http://www.webdesigntalk.net[/url]
//REPUBLICATION OF THE TUTORIAL REQUIRES OUR PERMISSION.
//[email protected]
//
//
//
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. Unzip the file you just downloaded to a temporary directory. If you're using a program such as Winzip and it gives you the option to install now go ahead and do that leaving all the default settings selected. If not browse to the temporary directory where you unzipped the files and click on the setup.exe file to start the installation. Continue through the installation with all the default settings until you're done. Browse to your C:mysqlbin directory and Click on the winmysqladmin.exe file. This should launch a graphical user interface that you can use to edit configuration files and maintain and monitor your MySQL server. You should see a screen with:
Create the mysql.ini file with default values and the user below. Reccomended to novice user. Enter a username and password that you will remember. Click Ok. You'll see a stoplight icon in your taskbar, you can stop the MySQL server and/or the WinMySQLAdmin tool by clicking on the icon.
This tutorial is meant to help you get started using MySQL, show you the basics of how it works, and show you some of the basic SQL (Structured Query Lanuage) syntax. There's other database software out there besides MySQL that also use the SQL syntax. Some of them are: MS-SQL, Microsoft Access, PostgreSQL, and Oracle. The reason MySQL is so popular is because of it's incredible performance and it's FREE!
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:
Code:
+---------------------+
| now() |
+---------------------+
| 2003-08-30 10:00:50 |
+---------------------+
1 row in set (0.00 sec)
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()
-> ;
Code:
+----------------+
| current_date() |
+----------------+
| 2003-08-30 |
+----------------+
1 row in set (0.00 sec)
You can select multiple values with a single command by separating them with a comma:
mysql> select current_date(), version(), current_time();
Code:
+----------------+-----------+----------------+
| current_date() | version() | current_time() |
+----------------+-----------+----------------+
| 2003-08-30 | 3.23.54 | 11:48:43 |
+----------------+-----------+----------------+
-> version(),
-> current_time();
Code:
+----------------+-----------+----------------+
| current_date() | version() | current_time() |
+----------------+-----------+----------------+
| 2003-08-30 | 3.23.54 | 11:51:14 |
+----------------+-----------+----------------+
1 row in set (0.00 sec)
mysql> select current_date(); select current_time(); select version();
Code:
+----------------+
| current_date() |
+----------------+
| 2003-08-30 |
+----------------+
1 row in set (0.00 sec)
+----------------+
| current_time() |
+----------------+
| 12:49:21 |
+----------------+
1 row in set (0.00 sec)
+-----------+
| version() |
+-----------+
| 3.23.54 |
+-----------+
1 row in set (0.00 sec)