mysql设置某列数据自增1 及设置后insert写法

 

+--------+--------------+------+-----+---------+----------------+
| Field  | Type         | Null | Key | Default | Extra          |
+--------+--------------+------+-----+---------+----------------+
| no     | int(11)      | NO   | PRI | NULL    |                    |
| name   | varchar(50)  | YES  |     | NULL    |                |
| src    | varchar(100) | YES  |     | NULL    |                |
| goods  | int(11)      | YES  |     | 0       |                |
| clicks | int(11)      | YES  |     | 0       |                |
| date   | datetime     | YES  |     | NULL    |                |
| author | varchar(50)  | YES  |     | NULL    |                |
| intro  | varchar(100) | YES  |     | NULL    |                |
+--------+--------------+------+-----+---------+----------------+

如上表pics

令no列数据自增，则：

alter table pics modify no int AUTO_INCREMENT;   （pics是表名，no是列名）

设置自增后insert写法：自增列数据输入0或null即可，如：

insert pics values(0,"wugui","pic/s",0,0,"2018-05-26","ss","ss");

insert pics values(null,"wugui","pic/s",0,0,"2018-05-26","ss","ss");

select * from pics;

+----+-------+-------+-------+--------+---------------------+--------+-------+
| no | name  | src   | goods | clicks | date                | author | intro |
+----+-------+-------+-------+--------+---------------------+--------+-------+
|  1 | wugui | pic/s |     0 |      0 | 2018-05-26 00:00:00 | ss     | ss    |
|  2 | wugui | pic/s |     0 |      0 | 2018-05-26 00:00:00 | ss     | ss    |
+----+-------+-------+-------+--------+---------------------+--------+-------+