mysql> CREATE DATABASE my_db CHARACTER SET utf8
mysql> show databases;
mysql> use my_db;
mysql> show tables;

mysql> CREATE TABLE people (id INT(12) not null auto_increment primary key, name VARCHAR(40), info VARCHAR(100));

mysql> describe people;  #shows schema

mysql> INSERT INTO people(name, info) VALUES("Sally, "abc") ;
mysql> SELECT * FROM people;

#Only use the following if you want to delete data:
mysql> drop table people;
mysql> drop database my_db;