Ò»¸ö¹ØÓÚ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-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÈçÌâ¡£ÎÒÒѾ°²×°ÁËmysqlodbcÇý¶¯¡£
adodc¿Ø¼þÊôÐÔÀïÃæ£¬Á¬½Ó×ÊÔ´£¬
ÓÐ
ʹÓÃDataLinkÎļþ
ʹÓÃODBCÊý¾Ý×ÊÔ´Ãû³Æ
ʹÓÃÁ¬½Ó×Ö·û´®
ÊÇÑ¡ÔñÄĸö£¿
È»ºóµÃ²½ÖèÊÇÔõôÑùµÄ£¿
HTML code:
http://www.connectionst ......
ÓÐÒ»¸öjsÎļþ£¬ÊÇʵÏÖÎÄ×Ö¹ö¶¯µÄ£¬ÆäÖеıäÁ¿ÐèÒªµ½mysqlÊý¾Ý¿âÖжÁÈ¡£¬ÄÇôÔõÑùʵÏÖÊý¾Ý¿âÁ¬½Ó¶ø¶ÁÈ¡Êý¾Ý£¿
ÎÒÊDzËÄñ£¬×îºÃÓÐÍêÕûµÄ´úÂëºÍ½âÊÍ£¬Ð»Ð»¸÷λ´óϺ°¡°¡°¡°¡°¡°¡£¡£¡£¡
http://blog.csdn.net/jemlee2002 ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
±¾ÈËÏëÖªµÀMySqlÔõôÔÚÊý¾Ý°²×°µÄʱºò¾ÍÄÜ×Ô¶¯È¥Éú³ÉһЩĬÈϵÄÓû§ºÍȨÏÞÄØ£¨Óû§£ºClient£¬ÃÜÂ룺12345£©£¿
±ÈÈçÊDz»ÊÇÐèҪд×Ô¶¯°²×°½Å±¾°¢£¿µÈµÈ£¬Ð»Ð»£¡
MySQLµÄ±ê×¼°²×°£¬»òÕ߷ǰ²×°°æ±¾Öв»»á°ïÄã´´½¨ÕâЩ ......