+--------+--------------+------+-----+---------+----------------+
| 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 |
+----+-------+-------+-------+--------+---------------------+--------+-------+