Tutorial to MySQL

Log in

$ mysql -u root -p 
Enter password: 

Show database

mysql> show databases;

Show table

mysql>  use test;     # test is one of your database 
mysql> show tables;

Create database

mysql> create database test;

Create table

mysql> create table mytest( id varchar(20) primary key, name varchar(20) not null);

Delete database

mysql> drop database test;

Delete table

mysql> drop table mytest;