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

MYSQLÖиù¾Ý×Ö¶ÎÖµÅжϷµ»Ø²»Í¬µÄÖµ

ÔÚmysqlÖÐÓÐÒ»ÕÅ±í£¬ÓÐÈý¸ö×Ö¶Îtotal,max, min£¬¶¼ÊÇintÐ͵ÄÖµ£¬¿ÉÒÔдһ¸ösqlÓï¾äÍê³É¹¦ÄÜ£º
¸ù¾ÝÿÌõ¼Ç¼ÖУ¬Èç¹ûtotal>max,·µ»Ø2£¬Èç¹ûtotal <min·µ»Ø1£¬Èç¹û¶¼Ìõ¼þ¶¼²»·ûºÏ·µ»Ø0¡£¼±Ç󣡣¡£¡£¡
mysql?

²îµã¿´³Éms sqlÁË.

ÊÔÊÔ:

SQL code:
select * ,case when total>max then 2
when total <min then 1
else 0
end
from ±í


select case when total > max then 2 else  case when total < min then 1 else null end end
from ta

case when

SQL code:
select case
when total > max then 2
when total < min then 1
else 0
end
from ta
ÊÔÊÔ

SQL code:
select case
when total > max then 2
when total < min then 1
else 0
end
from ta
ÊÔÊÔ

²»ºÃÒâ˼£¬ÒòΪÒѾ­ÓÐÈ˻شðÁË£¬ËùÒÔ½«·Ö¸øÁ˵ÚÒ»¸ö»Ø´ðµÄÈË£¡¼ûÁ£¡´ó¼ÒµÄ»Ø´ð¶¼Í¦¶ÔµÄ£¡


Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

Çó¾È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Êý¾Ý¿âµ ......

¹ØÓÚmysql´æ´¢¹ý³Ì±äÁ¿µÄÎÊÌ⣿

¹ØÓÚmysql´æ´¢¹ý³Ì±äÁ¿µÄÎÊÌ⣿±äÁ¿Ê²Ã´Ê±ºòÇ°ÃæÒª¼Ó@·ûºÅ£¬ÓÃdeclareÉùÃ÷µÄ±äÁ¿ÓëǰÕßÓкÍÇø±ð£¬ÎÒ²»¶®£¿
@ÊÇÓÃÀ´ÆÁ±Î´íÎó»ò¾¯¸æµÄ£¬µ±Ç°Ãæ¼ÓÁË@·ûºÅºó£¬Èô´Ë´¦Óдí»ò¾¯¸æ£¬ÍøÒ³½«²»ÏÔʾ³öÀ´¡£

Ç°Ãæ¼Ó@´ú±í»á»° ......

mysql±¸·ÝÎÊÌâ¡£¼±£¡£¡£¡£¡£¡

¸ßÊÖ£¬ÏÖÔÚÓöµ½Ò»¸ömysql±¸·ÝµÄÎÊÌâ¡£

ÎÒµÄÊý¾Ý¿âÀïÓÐһЩÓÃcreate function½¨Á¢µÄ×Ô¶¨Ò庯Êý¡£µ±ÎÒÓÃmysqldump±¸·Ý¸ÃÊý¾Ý¿âÈ»ºóµ¼Èëµ½ÁíÍâÒ»¸ö·þÎñÆ÷BÉÏ£¬·¢ÏÖ·þÎñÆ÷BÉÏÖ»ÓÐÊý¾Ý£¬¶øÃ»ÓÐÄÇЩ×Ô¶¨ÒåµÄº¯Êý¡£Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ