php批量產生mysql觸發器定義語句

簡介：這是php批量產生mysql觸發器定義語句的詳細頁面，介紹了和php,有關的知識、技巧、經驗，和一些php源碼等。

class='pingjiaF' frameborder='0' src='http://biancheng.dnbcw.info/pingjia.php?id=333669' scrolling='no'>

<?phpdefine('TRIGGER_AFTER_INSERT_SQL',"DELIMITER |DROP TRIGGER IF EXISTS %s;CREATE TRIGGER %sAFTER INSERT ON %sFOR 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 %sAFTER UPDATE ON %sFOR 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 %sAFTER DELETE ON %sFOR 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觸發器定義語句”的更多相關文章 》

愛J2EE關注Java邁克爾傑克遜視頻站JSON線上工具

http://biancheng.dnbcw.info/php/333669.html pageNo:11