PHP 利用 mysqli 建立 MySQL Trigger

<?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);