mysql id自动增加和时间戳

create table file_download(id int(5) not null auto_increment,login_name varchar(20) not null, name_id int(5) not null, file_name varchar(50) not null, download_time timestamp not null default current_timestamp on update current_timestamp, primary key(id));

insert into file_download (login_name,name_id,file_name) values('lamost',1001, 'ssam2344');

mysql> select * from file_download;                                             +----+------------+---------+-----------+---------------------+
| id | login_name | name_id | file_name | download_time       |
+----+------------+---------+-----------+---------------------+
| 1 | lamost     |    1001 | ssam2344 | 2017-11-19 23:53:53 |
| 2 | lamost     |    1001 | ssam2344 | 2017-11-19 23:54:26 |
+----+------------+---------+-----------+---------------------+
2 rows in set (0.00 sec)

原文链接：https://blog.csdn.net/coffeebreak/article/details/78578456