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

MySQL´´½¨´æ´¢¹ý³Ì³ö´í

ÔÚMySQL5.0Öд¬½¢´æ´¢¹ý³Ìͨ²»¹ý£¬Ìáʾ£º
[Err] 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 '' at line 54

ʵÔÚÕÒ²»³öÄÄÀï´íÁË£¬Çë¸ßÊÖÖ¸µãÒ»ÏÂ

´úÂëÈçÏ£º
SQL code:

CREATE DEFINER=`root`@`localhost` PROCEDURE `forum_register`(
in email varchar(30),
in password varchar(16),
in userName char(8),
in qq char(10),
in securityQuestion1 varchar(40),
in securityQuestion2 varchar(40),
in securityAnswer1 varchar(40),
in securityAnswer2 varchar(40),
in headPicture blob,
in registerTime datetime,
in participatedTopicsCount int,
in createdTopicsCount int,
in managingSectionID smallint,
in currentUploadSize float,
in state char(1)
)
begin
insert into forum_users(
Óû§Ãû,
ÓÊÏä,
²ÎÓëÖ÷ÌâÊý,
·¢ÆðÖ÷ÌâÊý,
ÃÜÂë,
QQ,
Í·Ïñ,
×¢²áʱ¼ä,
Ãܱ£ÎÊÌâ1,
Ãܱ£´ð°¸1,
Ãܱ£ÎÊÌâ2,
Ãܱ£´ð°¸2,
¹ÜÀí°æ¿éID,
µ±Ç°ÉÏ´«ÈÝÁ¿,
״̬


)
values(
userName,
email ,
participatedTopicsCount ,
createdTopicsCount,
password,
qq,
headPicture ,
registerTime,


Ïà¹ØÎÊ´ð£º

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

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

jsp±¸·ÝmysqlÖ»ÓпÕÎļþ

ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......

C#¶ÁÈ¡mysqlÊý¾Ý¿âÎÊÌâ

ÎÒʹÓÃC#Á¬½ÓmysqlÊý¾Ý¿â¶ÁÈ¡ÆäÖеÄÊý¾Ý£¬
¶ÁÈ¡Êý¾Ý±íÖеÄVarcharÀàÐ͵ÄÊý¾Ý£¬Èç¹ûÊÇÓ¢ÎÄÄܹ»Õý³£¶ÁÈ¡³öÀ´£¬
¶øÈç¹ûÊÇÖÐÎÄ£¬¾Í»áÏÔʾΪ¡°£¿£¿¡±£¬

Èç¹û°ÑvarcharÀàÐÍ»»³ÉbinaryÀàÐÍ£¬Asp.net³ÌÐòÄܹ»Õý ......

Çó¾ÈMySqlÄ£ºý²éѯÎÊÌâ

Java code:

Ä£ºý²éѯÊé°´ÕÕÊéÃû-------------------
java.sql.SQLException: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
at com.mys ......

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£©

ûÓС£

³ý·ÇÄã×Ô¼º¸ÄдһÏÂMYSQLµÄÔ´´úÂëÈ»ºó±àÒëÔËÐС£

½èÖúÆäËûÓïÑÔ

ĿǰµÄmysqlÀïÃæÏÖ³ÉÕâÑùµÄ¹¦ÄÜ¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ