MYSQL仅仅向某个字段进行插入

例子:

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>
原文地址:https://www.cnblogs.com/Robotke1/p/3192470.html