MYsqlÓÃʲô¹¤¾ß½øÐÐÊý¾Ý¿âµÄµ½´¦Äܽâ¾öÖÐÎÄÂÒÂëÎÊÌâ
ÎÊÌâÈçÌ⣬ ·¢ÏÖ´ÓmysqlÊý¾Ý¿âµ¼³öµÄÊý¾Ý±íÀïµÄÊý¾Ý£¬ÖÐÎͼÊÇÂÒÂë ÎÒÓõÄÊÇSQLyog Enterprise¹¤¾ßµ¼³öµÄ ÓÐʲôÃüÁîÖ±½Ó¿ÉÒÔµ¼³öÕû¸öÊý¾ÝÂð ÒªÊǹ¤¾ßÇë°ïæ¸æËßϵØÖ· лл
phpmyadmin²»¾ÍºÜºÃ£¡ Ö»Óùýsource http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx MySQL ÖÐÎÄÏÔʾÂÒÂëÒýÓà ÒýÓÃÂ¥Ö÷ cainiao66 µÄ»Ø¸´: ÎÊÌâÈçÌ⣬ ·¢ÏÖ´ÓmysqlÊý¾Ý¿âµ¼³öµÄÊý¾Ý±íÀïµÄÊý¾Ý£¬ÖÐÎͼÊÇÂÒÂë ÎÒÓõÄÊÇSQLyog Enterprise¹¤¾ßµ¼³öµÄ ÓÐʲôÃüÁîÖ±½Ó¿ÉÒÔµ¼³öÕû¸öÊý¾ÝÂð ÒªÊǹ¤¾ßÇë°ïæ¸æËßϵØÖ· лл ÕâЩÖÐÎÄÔÚÊý¾Ý¿âÖв»ÊÇÂÒÂë°É£¿Ò²¿ÉÒÔÓÃNavicat ºÜ¸Ðл Õâ¸öÈí¼þ²»´í ÎÒÊý¾Ý¿âÖÐÎÄÏÔʾ¶¼Õý³£ ¾ÍÊǵ¼³öµÄʱºòÖÐÎÄÊÇÂÒÂë лл´ó¼Ò
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл ½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£ http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5 ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
SQL code: CREATE PROCEDURE A() BEGIN DECLARE 'Constraint Violation' CONDITION FOR sqlexception; DECLARE EXIT HANDLER FOR 'Constraint Violation' ROLLBACK; BEGIN TRAN ......