Çómysql²éѯÁ·Ï°ÌâÄ¿£¡£¡£¡
ÎҵIJéѯÓï¾äдµÄÒ»Ö»ºÜ²î£¬ÏëÕÒЩÁ·Ï°ÌâÀ´×ö£¬ÇëÎÊ´ó¼ÒÓÐûÓкõķ½·¨ÄÄ£¿
¶àÉÏÂÛ̳¡¢¶à¿´¿´Ìù×Ó¡¢¶àÁ·Ï°
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡· (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî)
È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éMYSQLµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ£¬µÚ¼¸Ò³£©MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÊÇÇëÄãÃǸøÐ©Á·Ï°ÌâÄ¿°¢£¬ mysql²Î¿¼ÊÖ²áÎÒÔÚ¿´£¬µ«ÉÏÃæ¶Ô¶à±í²éѯûÔõô½²°¢
Õâ¸öµ¹ÊÇÈÝÒ×ÁË¡£
Äã¿ÉÒÔÖ±½ÓÕÒ±¾Ñ§Ð£ÀïµÄ¡¶Êý¾Ý¿âÔÀí¡·½Ì²Ä¡£ÉÏÃæ¾ÍÓ¦¸ÃÓÐרÃŵÄÁ½µ½ÈýÕ½²SQL£¬²¢ÇÒÓпκóÁ·Ï°¡£
ÉÏcsdnÂÛ̳µÄmysql°å¿é£¬È¥¿´Òѽâ¾öµÄÎÊÌ⣬ÊÔ×Å×öһϣ¬×öÍêÁËÔÙ¿´±ðÈ˵ĻشðÌØ±ðÊǵ÷ֵĺÍÐǼ¶µÄ»Ø´ð¡£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
SQL code:
CREATE PROCEDURE A()
BEGIN
DECLARE 'Constraint Violation'
CONDITION FOR sqlexception;
DECLARE EXIT HANDLER FOR
'Constraint Violation' ROLLBACK;
BEGIN TRAN ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......