问使用当前时间戳插入MySQL

EN

CREATE TABLE Orders (
id                  INTEGER(10) UNSIGNED AUTO_INCREMENT,
VendorName     VARCHAR(20),
Item             VARCHAR(20),
updated_at          TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
created_at          DATETIME DEFAULT NULL,
PRIMARY KEY (id)
);

Insert into Orders values(123,'PoppyCounter','Chocltae','now','now')

mysql> select * from Orders;
+-----+--------------+----------+---------------------+---------------------+
| id  | VendorName   | Item     | updated_at          | created_at          |
+-----+--------------+----------+---------------------+---------------------+
| 123 | PoppyCounter | Chocltae | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 |
+-----+--------------+----------+---------------------+---------------------+
1 row in set (0.00 sec)