Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

½ô¼±: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 ¿ÉÒÔÁË.лл


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

phpÎļþÄÜ·ñ±»±ðÈ˵ÁÈ¡?? - PHP / »ù´¡±à³Ì

ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ

¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......

php »ñÈ¡Ò³ÃæÄÚÈÝ - PHP / »ù´¡±à³Ì

Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ