Open mysql command line :

• $mysql -u root -p

password : Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.20 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

• mysql>

• if root haven't password remove -p

Show Databases :

• mysql> show databases;

• mysql>

Open database :

• mysql> use mysql;

Reading table information for completion of table and column names Database changed

• mysql>

Read table information:

• mysql>show tables;

6 rows in set (0.00 sec)

• mysql>

Creat new Database:

• mysql> create database hazem;

Query OK, 1 row affected (0.16 sec)

• mysql>

Creat Tables:

• mysql> create table Friends(id integer , name char(20));

Query OK, 0 rows affected (0.01 sec)

• mysql>

Insert Data into table:

• mysql> insert into Friends values(1,'alaa');

Query OK, 1 row affected (0.00 sec)

• mysql>

Center]Read information of table :

• mysql> select * from Friends;

6 rows in set (0.07 sec)

• mysql>

Delete Table :

• mysql> drop tablen Friends;

Query OK, 0 rows affected (0.05 sec)

• mysql>

Close Mysql :

• mysql>\q

Bye $