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

Ò»¸ö¹ØÓÚmysql´æ´¢¹ý³ÌµÄÎÊÌâ

ÎÒÏëд¸ö¶Ô±í½øÐвåÈëµÄ´æ´¢¹ý³ÌÓï¾ä£¬²»ÖªÎªÊ²Ã´ÀÏÊÇ˵ÎÒÓï·¨Óдí
Óï¾äÈçÏ£º
BEGIN
#Routine body goes here...
insert into t1(num, value, str) values(value1, value2, value3);
END;
Õâ¸öÊÇÔÚnavicatÏÂдµÄ¡£value1,value2Ϊint£¬value3Ϊvarchar¡£
´íÎóÈçÏ£º
1064-you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
BEGIN
        #Routine body goes here...
insert into t1(num, value, str) values(va' at line 1



Ìù³öÄãÍêÕûµÄÓï¾ä¡£

ÊÇͨ¹ýnavicat½¨µÄÒ»¸öprocedure,½¨ºÃÖ®ºó¾ÍÊDZ£´æÎªÒ»¸öprocedure¡£ÄǸö´íÎóÊDZ£´æÊ±³öµÄ

Ó¦¸ÃÊÇÊý¾ÝÀàÐ͵ÄÎÊÌ⣬ÓÉÓÚvalue3Ϊvarchar,ÄãÔÚдÈëvalue3µÄʱºòÒª¼ÓÒýºÅ£¬ÀýÈ磺'value3'
ÕâÑùÓ¦¸Ã¾ÍûÓÐÎÊÌâÀ²£»

Óï·¨ÉÏÓ¦¸ÃûÎÊÌâ
ÄãÏÈÓÃvalue1, value2, value3 ÓþßÌåµÄÊý¾ÝÌæ´úµô£¬È»ºóÔÙÒ»¸ö¸ö»»»ØÀ´£¬¿´¿´ÊÇʲôÎÊÌâ


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

ÇëÎÊʹÓÃado¿Ø¼þÁ¬½ÓmysqlÊý¾Ý¿âµÄ²½ÖèÊÇʲô

ÈçÌâ¡£ÎÒÒѾ­°²×°ÁËmysqlodbcÇý¶¯¡£
adodc¿Ø¼þÊôÐÔÀïÃæ£¬Á¬½Ó×ÊÔ´£¬
ÓÐ
ʹÓÃDataLinkÎļþ
ʹÓÃODBCÊý¾Ý×ÊÔ´Ãû³Æ
ʹÓÃÁ¬½Ó×Ö·û´®
ÊÇÑ¡ÔñÄĸö£¿
È»ºóµÃ²½ÖèÊÇÔõôÑùµÄ£¿
HTML code:
http://www.connectionst ......

JavaScriptÔõÑùÁ¬½ÓMySQLÊý¾Ý¿â£¿

ÓÐÒ»¸öjsÎļþ£¬ÊÇʵÏÖÎÄ×Ö¹ö¶¯µÄ£¬ÆäÖеıäÁ¿ÐèÒªµ½mysqlÊý¾Ý¿âÖжÁÈ¡£¬ÄÇôÔõÑùʵÏÖÊý¾Ý¿âÁ¬½Ó¶ø¶ÁÈ¡Êý¾Ý£¿
ÎÒÊDzËÄñ£¬×îºÃÓÐÍêÕûµÄ´úÂëºÍ½âÊÍ£¬Ð»Ð»¸÷λ´óϺ°¡°¡°¡°¡°¡°¡£¡£¡£¡
http://blog.csdn.net/jemlee2002 ......

mysql Îļþ¶ÁÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ 
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......

MySql ÔõôÔÚÊý¾Ý¿â°²×°µÄʱºò¾Í×Ô¶¯Éú³ÉĬÈÏÓû§ÄØ£¿

±¾ÈËÏëÖªµÀMySqlÔõôÔÚÊý¾Ý°²×°µÄʱºò¾ÍÄÜ×Ô¶¯È¥Éú³ÉһЩĬÈϵÄÓû§ºÍȨÏÞÄØ£¨Óû§£ºClient£¬ÃÜÂ룺12345£©£¿
±ÈÈçÊDz»ÊÇÐèҪд×Ô¶¯°²×°½Å±¾°¢£¿µÈµÈ£¬Ð»Ð»£¡
MySQLµÄ±ê×¼°²×°£¬»òÕ߷ǰ²×°°æ±¾Öв»»á°ïÄã´´½¨ÕâЩ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ