At MySql commandline :

use <databse>; --- Changes the database.
Show databases; --- Shows the databases created.
SELECT * FROM `users` LIMIT 0 , 30; --- displays 30 records from users table.

CREATE DATABASE `test` ; - Crates a database named test.

CREATE TABLE `Personal_details` (`Name` VARCHAR( 15 ) NOT NULL ,`P_NO` VARCHAR( 7 ) NOT NULL ,`City` VARCHAR( 10 ) NOT NULL ,`DOJ` DATE NOT NULL ,PRIMARY KEY ( `P_NO` ) ) COMMENT = 'Personal details of Employees';

- Creates a table named Personal details with Name, P_No, City and DOJ as fields.