//
//	Steps to run MySQL
//

1. After loging to your Linux account, you need to login to MySQL account by typing

	mysql -u user_name -p

2. Type your password and you will get into the MySQL database system 

	[jwang@zwang ~]$ mysql -u jwang -p
	Enter password: 

	Welcome to the MySQL monitor.  Commands end with ; or \g.
	Your MySQL connection id is 403 to server version: 5.0.22

	Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

	mysql>

3. Show all databases by typing

	show databases;
	
4. Enter into your database environment by typing

	use db_name
   
5. Show all tables in your database by typing

	show tables;

6. In your database, you can perform all SQL operations. Here are a few of common SQL statements:

	a) create a table

	create table STUDENT (ID int primary key, NAME varchar(20), SCORE int);

	b) Delete the table

	drop table STUDENT;

	c) insert a record

	insert into STUDENT values (100, "Jon Smith", 87);

	d) display the table

	select * from STUDENT;

7. To run the script sql file (each of the above SQL statements ended with a semi-colon ;) that is located in the current directory, type

	source file.sql 

8. To exit from the MySQL, type

	exit