mysql> create table book(num int,name varchar(20),office varchar(20));
Query OK, 0 rows affected (0.07 sec)



mysql> show tables
+----------------+
| Tables in test |
+----------------+
| book           |
+----------------+

1 row in set (0.00 sec)



mysql> desc book
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| num    | int(11)     | YES  |     | NULL    |       |
| name   | varchar(20) | YES  |     | NULL    |       |
| office | varchar(20) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+

3 rows in set (0.00 sec)
                         



mysql> insert into book values('1','ȫ浿','');
Query OK, 1 row affected (0.00 sec)



mysql> select * from book;
+------+--------+--------+
| num  | name   | office |
+------+--------+--------+
|    1 | ȫ浿 |   |
+------+--------+--------+

1 row in set (0.00 sec)



mysql> insert into book values('2','Ӳ','Z');
Query OK, 1 row affected (0.00 sec)



mysql> select * from book;

+------+--------+--------+
| num  | name   | office |
+------+--------+--------+
|    1 | ȫ浿 |   |
|    2 | Ӳ | Z   |
+------+--------+--------+

2 rows in set (0.00 sec)