Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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,


Ïà¹ØÎÊ´ð£º

¹ØÓÚMYSQLµ¥±í´æ´¢ÎÊÌâ

Êý¾Ý¿âÒýÇæʹÓÃMYISAM
ÀýÈç±íÃû£ºLOG¡¡Ã¿Ìì»á²úÉú400Íò×óÓҵļǼ

ÈÕ»ýÔÂÀÛÊý¾ÝÁ¿»á·Ç³£Ö®³è´ó

ËùÒÔ¿¼Âǵ½Õâµã
ÎÒÏëÁËÁ½¸ö·½°¸
1¡¢Ã¿Ìì²úÉúÒ»¸ö±í£¬ÀàËÆLOG20091010¡¢LOG20091011
2¡¢Ã¿Ìì ......

ÍøÕ¾¾µÏñ£¬Ö÷ÍøÕ¾ºÍ¾µÏñÍøÕ¾MysqlÊý¾Ýͬ²½

ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ

ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý ......

Çó¾È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·þÎñÆ÷£¬Êý¾Ýͬ²½

ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ

ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµ ......

CÓïÑÔ Mysql ÒÉÎÊ

if(mysql_init(&mysql)==NULL)
{
sprintf(ErrMsg,"We are outof Memory");
return(false);
}

if(!mysql_real_connect(&mysql,"localhost","test" ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ