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

 20 MySQL¿Í»§¹¤¾ßºÍAPI
20.1 MySQL C API
C API´úÂëÊÇËæMySQL·Ö·¢µÄ£¬Ëü±»°üº¬ÔÚmysqlclient¿âÇÒÔÊÐíC³ÌÐò´æÈ¡Ò»¸öÊý¾Ý¿â¡£
ÔÚ MySQLÔ´´úÂë·Ö·¢Öеĺܶà¿Í»§ÊÇÓÃC±àдµÄ¡£Èç¹ûÄãÕýÔÚѰÕÒÑÝʾÔõÑùʹÓÃC APIµÄÀý×Ó£¬¿´Ò»ÏÂÕâЩ¿Í»§³ÌÐò¡£
´ó¶àÊýÆäËû¿Í»§ API(³ýÁËJavaµÄËùÓÐ)¶¼Ê¹ÓÃmysqlclient¿âÓëMySQL·þÎñÆ÷ͨÐÅ ......

mysqlÊý¾Ý¿âģʽÐÅÏ¢ÌáÈ¡

´Ë³ÌÐòʵÏÖ½«mysqlÊý¾Ý¿âµÄģʽÐÅϢչʾ³öÀ´¡£ÏÂÃæÎÒ¼òÒªµØËµÃ÷һϡ£
1.Ê÷ÐνṹµÄʵÏÖ¡£
 SimplePanel pl=new SimplePanel();
private void buildFrameLayout(){
try{ pane = getContentPane();
//¹Ø±ÕÃæ°å
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
//BorderLayout²¼¾Ö¹ÜÀíÆ÷
JPanel ......

MySQLתÒå

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

Tomcat+MySQl JDBCÁ¬½Ó³ØµÄÅäÖÃ

1¡¢°²×°Tomcat
JDBCÁ¬½Ó³ØÅäÖõĵÚÒ»²½ÊÇÏÂÔØºÍ°²×°Tomcat¡£²Î¿¼Tomcat for window µÄ°²×°Ïòµ¼£¬»ù±¾Ö±½Ó°²×°¼´¿É£¬×¢Ò⣺°²×°Ê±»áÌáʾÊäÈë¹ÜÀíÓû§ÃûºÍÃÜÂ룬ÕâÊÇÒÔºó»áÓõ½µÄÓû§ÃûºÍÃÜÂ룬Çмǡ£
2¡¢°²×°MySql
ĬÈϰ²×°¼´¿É¡£
3¡¢Ê¹ÓÃTomcatµÄWeb¹ÜÀíÓ¦ÓÃÅäÖÃÊý¾ÝÔ´
Æô¶¯Tomcat·þÎñÆ÷£¬´ò¿ªä¯ÀÀÆ÷£¬ÊäÈëhttp://loca ......

Çë×¢Òâ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ºÅ