1. How to login mysql from GNU/Linux shell ?
$mysql -h hostname -u root -p
2. How to create a database ?
mysql> create database [Database_Name];
3. How to list all databases ?
mysql> show databases;
4. How to list all the tables in a database ?
mysql> show tables;
5. How to switch to a database ?
mysql> use [Database_Name];
6. How to list database field formats in a table ?
mysql> describe [Table_Name];
7. How to delete a database ?
mysql> drop database [Database_Name];
8. How to delete a table ?
mysql> drop table [Table_Name];
9. How to list all data in a table ?
mysql> SELECT * FROM [Table_Name];
10. How to list certain selected rows with the value “yes”.
SELECT * FROM [Table_Name] WHERE [Field_Name] = “yes”;
11. How to list all records containing the name “verman” AND the phone number ’26235208′.
SELECT * FROM [Table_name] WHERE [Field_Name] = “verman” AND [Field_Name] = ’26235208′;
12. How to list all records not containing the name “verman” AND the phone number ’26235208′ order by the Field_Name phone_number ?
SELECT * FROM [Table_Name] WHERE name != “verman” AND phone_number = ’26235208′ order by phone_number;
13. How to list all records starting with the letters ‘verman’ AND the phone number ’26235208′ ?
SELECT * FROM [Table_Name] WHERE name like “verman%” AND phone_number = ’26235208′;