php批量生成mysql触发器定义语句
<?php define('TRIGGER_AFTER_INSERT_SQL',"DELIMITER | DROP TRIGGER IF EXISTS %s; CREATE TRIGGER %s AFTER INSERT ON %s FOR EACH ROW BEGIN SET @result_set = (select clear_cache()); END | DELIMITER ;/r/n/r/n"); define('TRIGGER_AFTER_UPDATE_SQL',"DELIMITER | DROP TRIGGER IF EXISTS %s; CREATE TRIGGER %s AFTER UPDATE ON %s FOR EACH ROW BEGIN SET @result_set = (select clear_cache()); END | DELIMITER ;/r/n/r/n"); define('TRIGGER_AFTER_DELETE_SQL',"DELIMITER | DROP TRIGGER IF EXISTS %s; CREATE TRIGGER %s AFTER DELETE ON %s FOR EACH ROW BEGIN SET @result_set = (select clear_cache()); END | DELIMITER ;/r/n/r/n"); mysql_connect('127.0.0.1:3307','root','') or die(mysql_error()); mysql_select_db('db'); mysql_query('SET NAMES UTF8'); $triggerDDL = ''; $rs = mysql_query('SHOW TABLES'); while($row = mysql_fetch_array($rs)) { $tblName = $row['Tables_in_db']; $triggerDDL .= "/r/n--/r/n-- 表的触发器 `".$tblName."`/r/n--/r/n"; $triggerName = $tblName.'_insert'; $triggerDDL .= sprintf(TRIGGER_AFTER_INSERT_SQL,$triggerName,$triggerName,$tblName); $triggerName = $tblName.'_update'; $triggerDDL .= sprintf(TRIGGER_AFTER_UPDATE_SQL,$triggerName,$triggerName,$tblName); $triggerName = $tblName.'_delete'; $triggerDDL .= sprintf(TRIGGER_AFTER_DELETE_SQL,$triggerName,$triggerName,$tblName); } file_put_contents('db_trigger.sql',$triggerDDL); ?>
欢迎大家阅读《php批量生成mysql触发器定义话语》,跪求各位点评，by 搞代码
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：php批量生成mysql触发器定义话语
转载请注明原文链接：php批量生成mysql触发器定义话语
