mysql数据库创建，表创建，插入数据

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
--显示所有的数据库
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.09 sec)
--创建一个数据库test2
mysql> create database test2;
Query OK, 1 row affected (0.00 sec)
--使用数据库test2
mysql> use test2;
Database changed
--显示test2中的所有表
mysql> show tables;
Empty set (0.00 sec)
--创建一个mytable表
mysql> create table mytable (name varchar(20), sex char(1),
    -> birth date, birthaddr varchar(20));
Query OK, 0 rows affected (0.14 sec)
--显示数据库中的所有表
mysql> show tables;
+-----------------+
| Tables_in_test2 |
+-----------------+
| mytable         |
+-----------------+
1 row in set (0.02 sec)
--显示表结构
mysql> describe mytable;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| name      | varchar(20) | YES  |     | NULL    |       |
| sex       | char(1)     | YES  |     | NULL    |       |
| birth     | date        | YES  |     | NULL    |       |
| birthaddr | varchar(20) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
4 rows in set (0.07 sec)
--查询表的所有字段
mysql> select * from mytable;
Empty set (0.00 sec)
--向表中插入一条记录
mysql> insert into mytable
    -> values(
    -> 'abc','f','1988-07-07','chian');
Query OK, 1 row affected (0.08 sec)
--查看表的记录
mysql> select * from mytable;
+------+------+------------+-----------+
| name | sex  | birth      | birthaddr |
+------+------+------------+-----------+
| abc  | f    | 1988-07-07 | chian     |
+------+------+------------+-----------+
1 row in set (0.00 sec)