Mysql应用案例

手动插入时间

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19


  CREATE DATABASE test;
  USE test;								

  CREATE TABLE goods(
  id INT(11) PRIMARY KEY,
  add_time DATETIME
  );

  CREATE TABLE orders(
  o_id INT(11) PRIMARY KEY,
  add_time DATETIME,
  goods_id INT(11),
  CONSTRAINT goo_ord FOREIGN KEY(goods_id) REFERENCES goods(id)
  );

  INSERT INTO goods (id, add_time) VALUES (123, '2023-10-06 12:34:56');
  INSERT INTO orders (o_id, add_time, goods_id) VALUES (1, '2023-10-06 12:34:56', 123);
  UPDATE orders SET add_time = '2023-10-07 09:00:00' WHERE o_id = 1;
  SELECT * FROM orders;

自动插入时间

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19


  CREATE DATABASE test;
  USE test;

  CREATE TABLE goods(
  id INT(11) PRIMARY KEY,
  add_time DATETIME
  );

  CREATE TABLE orders(
  o_id INT(11) PRIMARY KEY,
  add_time DATETIME,
  goods_id INT(11),
  CONSTRAINT goo_ord FOREIGN KEY(goods_id) REFERENCES goods(id)
  );

  INSERT INTO goods (id, add_time) VALUES (123, NOW());
  INSERT INTO orders (o_id, add_time, goods_id) VALUES (1, NOW(), 123);
  UPDATE orders SET add_time = NOW() WHERE o_id = 1;
  SELECT * FROM orders;