[PHP] 利用 mysqli 建立 MySQL Trigger

原始碼

1. <?php  
2. $dbAdapter = new mysqli('host', 'user', 'pass', 'db'); 
3.  
4. $sql = " 
5. DROP TRIGGER IF EXISTS `table_insert_trigger`; 
6.  
7. CREATE TRIGGER `table_insert_trigger` BEFORE INSERT ON `table` 
8. FOR EACH ROW  
9.    SET NEW.`CreateDate`=NOW(); 
10. "; 
11.  
12. $dbAdapter->multi_query($sql); 

<?php 
$dbAdapter = new mysqli('host', 'user', 'pass', 'db');

$sql = "
DROP TRIGGER IF EXISTS `table_insert_trigger`;

CREATE TRIGGER `table_insert_trigger` BEFORE INSERT ON `table`
FOR EACH ROW 
    SET NEW.`CreateDate`=NOW();
";

$dbAdapter->multi_query($sql);

就是這麼簡單，為什麼都沒有人寫文章，害我找好久！囧

參考文章：
How To Use Triggers to Track Changes in MySQL
MySQL / PHPMyAdmin Trigger Syntax