Introduction: This is a detailed page for PHP to generate MySQL trigger definition statements in batches. It introduces PHP, related knowledge, skills, experience, and some PHP source code.
Class = 'pingjiaf' frameborder = '0' src = 'HTTP: // biancheng.dnbc?info/pingjia.php? Id = 333669 'rolling = 'no'>
<? Phpdefine ('triggers _ 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 "); define ('triggers _ 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 "); define ('tr Igger_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 "); mysql_connect ('2017. 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 = $ R Ow ['tables _ in_db ']; $ triggerddl. = "\ r \ n -- table trigger '". $ 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, $ t Riggername, $ triggername, $ tblname);} file_put_contents ('db _ trigger. SQL ', $ triggerddl);?>
More articles about "batch generate MySQL trigger definition statements in PHP"
Love J2EE follow Java Michael Jackson video station JSON online tools
Http://biancheng.dnbcw.info/php/333669.html pageno: 11.