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)