| ID: 140 |
Category: MySQL |
Date Posted: 07/02/2010 |
Page Impressions : 4,870 |
|
 |
MySQL commands list. MySQL using the terminal. |
|
MySQL commands list. MySQL using the terminal.
Here is a list of commands that can be entered in the terminal to create, drop, show and use MySQL
You first need access to MySQL. Enter the following command in the terminal:-
mysql -u root -p
Enter your MySQL password. The MySQL command prompt should now be visible in the terminal.
MySQL Commands List
To create a new database enter the following in the terminal:-
mysql> create database test;
To delete the database enter the following in the terminal:-
mysql> drop database test;
To exit MySQL enter the following in the terminal:
mysql> \c
Then enter
mysql> exit
MySQL will display the message BYE
|
|
|
