½ô¼±:PHPÖÐÖ´ÐжàÌõsql±¨´í:ÓÃÓÚ´´½¨trigger.
ÔÚphpÖÐÒª¶¯Ì¬µÄ´´½¨Ò»¸ötrigger.ÒòΪ¶àÌõÓï¾ä.phpÔËÐоͱ¨´í.´óÌåÊÇÕâÑù×ÓдµÄ: SQL code: DELIMITER // CREATE TRIGGER tb_1_after_ins_tr AFTER INSERT ON tb_1 FOR EACH ROW BEGIN DECLARE guid INT; DECLARE oldGuid INT; //ÆäËûÊ¡ÂÔÁË.... END// DELIMITER ; È»ºó¾Í˵µÚÒ»ÐÐ:DELIMITER //´¦ÓдíÎó.ÄѵÀÕâÀï²»ÄÜÕâôÓÃÂï???лл´ó¼Ò
ÔÚʵ¼ÊÏîÄ¿Öл¹ÊDz»ÒªÓÃtrigger±È½ÏºÃ...ÒýÓà ÔÚʵ¼ÊÏîÄ¿Öл¹ÊDz»ÒªÓÃtrigger±È½ÏºÃ... û·¨×Ó°¡.±ðÈËдµÄ. A: mysql¿âÖеÄmysql_queryÒ»´ÎÖ»ÄÜÖ´ÐÐÒ»ÌõSQLÓï¾ä¡£ ½¨ÒéʹÓÃPHP5ÖеÄmysqli¿â£¬ Õâ¸ö¿âÖÐÓÐmysqli_multi_queryÕâ¸öÖ¸ÁîÈ¥´¦Àí£¬ ¾Í²»ÓÃ×Ô¼º·Ö¸î³ÉÒ»¾äÒ»¾äÀ´Ö´ÐÐÁË¡£ B: ×î¼òµ¥µÄ°ì·¨£¬ÔÚMySQLµÄÁ¬½Ó×Ö·û´®ÖÐÉèÖÃallowMultiQueries²ÎÊýÖÃΪtrue¡£¶øÇÒ£¬Ö»ÓÐMySQL Connector/J 3.1.1ÒÔÉϰ汾²ÅÖ§³Ö¡£ ½¨Á¢Á¬½ÓʱÉèÖÃһϾͿÉÒÔÁË£¬È磺jdbc:mysql://127.0.0.1/sample?user=root&password=&allowMultiQueries=true ÕÒµ½ÁËÕâЩ.ÏÈÊÔÊÔ mysqli_multi_query ¿ÉÒÔÁË.лл
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jas ......
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿ ¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖà ¿´Äã¶ÔÎļþȨÏÞµÄÉèÖà ......
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url) ²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È« Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......