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

mysqlÓëOracle updateµÄÇø±ð

update £ºµ¥±íµÄ¸üв»ÓÃ˵ÁË£¬Á½ÕßÒ»Ñù£¬Ö÷Ҫ˵˵¶à±íµÄ¸üÐÂ
   
       Oracle> OracleµÄ¶à±í¸üÐÂÒªÇó±È½ÏÑϸñ£¬ËùÒÔÓеÄʱºò²»ÊǺܺÃд£¬ÎÒÃÇ¿ÉÒÔÊÔÊÔOracleµÄÓαê
                    £¨Óαê²Î¿¼£ºhttp://blog.csdn.net/lovelyhermione/archive/2009/08/18/4457500.aspx£©
          update £¨
                   select t.charger_id_ new_charger_id_
                   from t_cus_year_status t
                   left join t_customer_infos cus on cus.id_ = t.cus_id_
                   where....
        £© n  set  n.new_charger_id_ =6;
   
     mysql>
                   update t_cus_year_status t
                     left join t_customer_infos cus on cus.id_ = t.cus_id_
                   set t.charger_id_  =6
                   where......;


Ïà¹ØÎĵµ£º

mysql Æð¶¯´íÎó½â¾ö°ì·¨

mysql Æð¶¯´íÎó½â¾ö°ì·¨- -
                                      
Access denied for user ''@'localhost' to d ......

Struts2+Spring+HibernateÁ¬½ÓmysqlÖÐÎÄÂÒÂë½â¾ö

1.struts.xmlÖÐÉèÖÃ
<constant name="struts.il8n.encoding" value="UTF-8"></constant>
2.jspÒ³ÃæÉèÖÃ
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
3.Êý¾Ý¿âÁ¬½Óurl
jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=u ......

MySQLתÒå

MySQLʶ±ðÏÂÁÐתÒå×Ö·û£º    
   
  \0    
  Ò»¸öASCII   0   (NUL)×Ö·û¡£    
  \n    
  Ò»¸öÐÂÐзû¡£    
  \t   &nb ......

MySQLѧϰ

C APIÏà¹Ø
C APIÊý¾ÝÀàÐÍ
 MYSQL
¸Ã½á¹¹´ú±í1¸öÊý¾Ý¿âÁ¬½ÓµÄ¾ä±ú¡£¼¸ºõËùÓеÄMySQLº¯Êý¾ùʹÓÃËü¡£²»Ó¦³¢ÊÔ¿½±´MYSQL½á¹¹¡£²»±£Ö¤ÕâÀ࿽±´½á¹û»áÓÐÓá£
 MYSQL_RES
¸Ã½á¹¹´ú±í·µ»ØÐеIJéѯ½á¹û£¨SELECT, SHOW, DESCRIBE, EXPLAIN£©¡£ÔÚ±¾½ÚµÄÊ£Óಿ·Ö£¬½«²éѯ·µ»ØµÄÐÅÏ¢³ÆÎª“½á¹û¼¯&rdq ......

Çë×¢ÒâMYSQLÓï¾äÖеÄÒýºÅ

SQL #1: select * from uchome_feed where uid in('0',501...) order by dateline desc limit 0,50;
SQL #2: select * from uchome_feed where uid in(0,501...) order by dateline desc limit 0,50;
SQL #1  ÊÇCSDN ¸öÈ˿ռä»ñÈ¡¸öÈ˶¯Ì¬µÄSQL£¬ÊôUCHÔ­°æSQL¡£
SQL #2 ÊÇÈ¥µôµ¥ÒýºÅ(SQL #1ÖкìÉ«²¿·Ö)ºóµÄSQL£¬Á½¸ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ