例子:
mysql> show create table student G *************************** 1. row *************************** Table: student Create Table: CREATE TABLE `student` ( `age` int(3) NOT NULL default '0', `energy` int(11) default '0', `the_time` date default NULL, PRIMARY KEY (`age`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 1 row in set (0.03 sec) mysql> insert into student (age) values(7), (8), (9); // 这里仅仅对age字段进行操作 Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql>