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


Ïà¹ØÎÊ´ð£º

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

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

¹ØÓÚMySQLµÄ²éѯ½á¹û

´úÂëÈçÏ£º
$sql = "select count(*) from admin";
$result = mysql_query($sql);
$num=mysql_num_rows($result);
echo $num;
Ϊʲô²»¹ÜÎҵļǼÓжàÉÙÌõ£¬¶¼ÊÇÊä³ö1£¬
ÎÒÏëÊä³ö²éѯµÄ ......

Çó¾È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Êý¾Ý¿âµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ