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)--创建一个数据库test2mysql> create database test2;Query OK, 1 row affected (0.00 sec)--使用数据库test2mysql> 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)