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

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£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

MYSQLÊÂÎñ»Ø¹öµÄÎÊÌâ

SQL code:

CREATE PROCEDURE A()
BEGIN
DECLARE 'Constraint Violation'
CONDITION FOR sqlexception;
DECLARE EXIT HANDLER FOR
'Constraint Violation' ROLLBACK;
BEGIN TRAN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ