在MySQL中，创建一个存储引擎为InnoDB，字符集为GBK的表TEST，字段为ID和NAME

mysql> CREATE TABLE `TEST`(`ID` INT(4) NOT NULL, `NAME` VARCHAR(20) NOT NULL)ENGINE=InnoDB DEFAULT CHARSET=GBK;
Query OK, 0 rows affected (0.67 sec)
mysql> DESC TEST;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(4)      | NO   |     | NULL    |       |
| name  | varchar(20) | NO   |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.09 sec) 
复制

mysql> INSERT INTO TEST(ID,NAME) VALUES(1,"newlhr");
Query OK, 1 row affected (0.09 sec)
mysql> SELECT * FROM TEST;
+----+--------+
| id | name   |
+----+--------+
|  1 | newlhr |
+----+--------+
1 row in set (0.00 sec)
复制

mysql> INSERT INTO TEST VALUES(2,"小麦苗"),(3,"ximaimiao");
Query OK, 2 rows affected (0.27 sec)
Records: 2  Duplicates: 0  Warnings: 0
mysql> SELECT * FROM TEST;
+----+-----------+
| id | name      |
+----+-----------+
|  1 | newlhr    |
|  2 | 小麦苗    |
|  3 | ximaimiao |
+----+-----------+
复制

mysql> SELECT * FROM TEST WHERE NAME="newlhr";
+----+--------+
| id | name   |
+----+--------+
|  1 | newlhr |
+----+--------+
mysql> SELECT * FROM TEST WHERE ID>1;
+----+-----------+
| id | name      |
+----+-----------+
|  2 | 小麦苗    |
|  3 | ximaimiao |
+----+-----------+
复制

mysql> UPDATE TEST SET NAME="oldlhr" WHERE ID=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0 
mysql> SELECT * FROM TEST;
+----+-----------+
| id | name      |
+----+-----------+
|  1 | oldlhr    |
|  2 | 小麦苗    |
|  3 | ximaimiao |
+----+-----------+
复制

mysql> ALTER TABLE TEST ADD AGE TINYINT(4) AFTER ID;
Query OK, 3 rows affected (0.04 sec)
Records: 3  Duplicates: 0  Warnings: 0
mysql> DESC TEST;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(4)      | NO   |     | NULL    |       |
| age   | tinyint(4)  | YES  |     | NULL    |       |
| name  | varchar(20) | NO   |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
复制