MySQL：建表，默认获取执行时时间
代码：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
mysql> create table time_base_tb(id int,name varchar(30),create_time timestamp not null default current_timestamp) engine=InnoDB default charset=utf8; Query OK, 0 rows affected (0.39 sec) mysql> desc time_base_tb; +-------------+-------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+-------------------+-------+ | id | int(11) | YES | | NULL | | | name | varchar(30) | YES | | NULL | | | create_time | timestamp | NO | | CURRENT_TIMESTAMP | | +-------------+-------------+------+-----+-------------------+-------+ 3 rows in set (0.00 sec) mysql> mysql> select * from time_base_tb; Empty set (0.00 sec) mysql> mysql> insert into time_base_tb(id,name) values(1,"Lenka"); Query OK, 1 row affected (0.00 sec) mysql> select * from time_base_tb; +------+-------+---------------------+ | id | name | create_time | +------+-------+---------------------+ | 1 | Lenka | 2017-07-04 23:52:09 | +------+-------+---------------------+ 1 row in set (0.00 sec) mysql> mysql> insert into time_base_tb(id,name) values(2,"Lee Home"); Query OK, 1 row affected (0.00 sec) mysql> mysql> select * from time_base_tb; +------+----------+---------------------+ | id | name | create_time | +------+----------+---------------------+ | 1 | Lenka | 2017-07-04 23:52:09 | | 2 | Lee Home | 2017-07-04 23:52:32 | +------+----------+---------------------+ 2 rows in set (0.00 sec) mysql> |
添加：
ALTER TABLE table1
ADD COLUMN createtime timestamp NULL DEFAULT CURRENT_TIMESTAMP
修改：
alter table table1
change createtime newtime timestamp null default current_timestamp
————————————————
Done。
