› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
uti6770werty
V2EX  ›  MySQL

MySQL 5.1 DELETE 触发器,取旧时间值不正确的问题

  •  
  •   uti6770werty · Apr 20, 2022 · 1936 views
    This topic created in 1627 days ago, the information mentioned may be changed or developed.
    CREATE TABLE `dll` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `lname` varchar(30) DEFAULT NULL,
      `lid` varchar(5) DEFAULT NULL,
      `create_at` timestamp NULL DEFAULT NULL,
      `update_at` timestamp NULL DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
    
    CREATE TRIGGER `insertrow_dll` BEFORE INSERT ON `dll` FOR EACH ROW SET NEW.`create_at`=NOW();
    CREATE TRIGGER `deleterow_dll` AFTER  DELETE ON `dll` FOR EACH ROW 
    INSERT INTO ell (lname,lid,create_at,update_at) VALUES (old.lname,old.lid,old.create_at,now());
    

    期望删除 dll 一行数据,其实是移过去 ell ,应该把创建时间也带过去,
    在 ell 看到 create_at,update_at ,取值都被设置成了 NOW(),
    是因为什么原因呢?

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2292 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 36ms · UTC 06:46 · PVG 14:46 · LAX 23:46 · JFK 02:46
    ♥ Do have faith in what you're doing.