如何通过Schema API添加触发器到mysql [英] How add trigger to mysql Through Schema API

问题描述

通过Schema API（文件夹中的文件mymodule.install文件夹\all\modules\mymodule）。
触发mysql：

 分隔符| 
 
 CREATE TRIGGER testref AFTER INSERT ON users 
 FOR EACH ROW BEGIN 
 INSERT INTO beep SET uid = NEW.uid; 
 END; 
 | 
 
分隔符; 
  

解决方案

没有具体的API。 >

尝试 http://api.drupal.org/api/drupal/includes--database.pgsql.inc/function/db_query/6

还要记住，触发器不是跨不同的数据库标准化。这将是一个更好的主意（或者也许作为一个回退）使用hook_user（）。

Through Schema API (file mymodule.install in Folder sites\all\modules\mymodule). trigger in mysql:

delimiter |

    CREATE TRIGGER testref AFTER INSERT ON users
      FOR EACH ROW BEGIN
        INSERT INTO beep  SET uid = NEW.uid;
      END;
    |

    delimiter ;

解决方案

There is no specific API for that.

Try http://api.drupal.org/api/drupal/includes--database.pgsql.inc/function/db_query/6

Also remember that triggers are not standardised across different databases. It would be a better idea (or maybe as a fallback) to do that with hook_user().

这篇关于如何通过Schema API添加触发器到mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！