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;
