Few MySQL Commands

1. Login to mysql database
#mysql -h [hostname] -u root -p

2. Create a new database
mysql> create database [database name]

3. To delete a database.
mysql> drop database [database name]

4. Display all the databases on the server
mysql> show databases;

5. Switch to database
mysql> use [database];

6. To see database's field formats.
mysql> describe [table];

7. To show all the tables in selected database.
mysql> show [tables];

8. Show all data in a table.
mysql> SELECT * FROM [table name];

9. Show the columns.
mysql> show columns from [table name];

10. Search a particular entry in table
mysql> SELECT * FROM [table name] WHERE [field name] = "???????";
eg. mysql> SELECT * FROM [user] WHERE User = "testuser" AND Host = 'localhost';

11.