Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

mysqlÊý¾ÝÒÆÖ²µ½sql server or oracleÉÏ

mysqlÊý¾ÝÒÆÖ²µ½sql server or oracleÉÏ
ÀûÓÃËüÃǵĵ¼È룬µ¼³ö¹¦ÄÜ¡£

NTSQL¹ÙÍøµÄ MySQL Migration Toolkit ¿ÉÒÔÊÔһϡ£

mysqldump --compatible=oracle¼´¿ÉÊä³öoracle¼æÈݸñʽ¡£


¸ü¶àµÄÒâ¼ûÄØ£¿

ÒýÓÃ
¸ü¶àµÄÒâ¼ûÄØ£¿


¸ü¶àµÄÒâ¼û¾ÍÊǽ¨ÒéÄãÏÈÊÔһϣ¬ÓÐʲô²»ºÏÊʵĴó¼ÒÔÙ°ïæÏë°ì·¨¡£

......

MySqlµÄ´æ´¢¹ý³ÌÀïÈçºÎÌí¼ÓÒ»¸öÊÂÎñ£¿Çë¸ßÊÖÖ¸µã£¡


[code=MySql]
begin
  SELECT *  from table1 where status = 0;
  update  table1 set status = 1 where status =0;
end

[/code]

ÎÒÊÇͨ¹ý  Navicat 8 for MySql ¹¤¾ßÀ´½¨µÄ´æ´¢¹ý³Ì£¬
ÎÒÏëÔÚÕâ¸ö´æ´¢¹ý³ÌÀï¼Ó¸öÊÂÎñ£¬ÈçºÎÓÐÒ»Ìõʧ°ÜÂíÉϻعö£¬

Ï£Íû´ó¼ ......

ÔõôÓÃJava´úÂë»òsql¶ÔMysql½øÐж¨Ê±±¸·ÝÊý¾Ý¿â

ÔõôÓÃJava´úÂë»òsql¶ÔMysql½øÐж¨Ê±±¸·ÝÊý¾Ý¿â £¬Java´úÂë »òÓÃSQLÓï¾äʵÏֵͼ¿ÉÒÔ
ÔÚjava´úÂëÖе÷ÓÃmsyqlÃüÁîÐУ¬ÓÃProcessµ÷ÓÃ
ÀýÈ磺Process process = null;
process = Runtime.getRuntime().exec("sqlÓï¾ä");
             

......ÄÜ˵µÄÏêϸµã²»£¿
......

¹ØÓÚmysqlµÄÒ»¸öÎÊÌ⣬лл

ÇëÎÊÕâÀïµÄquestionsÊÇʲôÒâ˼°¡£¬»¹ÓÐopens,´ò¿ªÊ²Ã´±íÄØ,лл


mysqladmin statusÃüÁîµÄ½á¹ûÏÔʾÏÂÃæµÄÖµ

Questions

·þÎñÆ÷Æô¶¯ÒÔÀ´¿Í»§µÄÎÊÌâ(²éѯ)ÊýÄ¿

Opens

·þÎñÆ÷ÒѾ­´ò¿ªµÄÊý¾Ý¿â±íµÄÊýÁ¿


Flush tables

·þÎñÆ÷ÒѾ­Ö´ÐеÄflush ...¡¢refreshºÍreloadÃüÁîµ ......

mysqlÁ¬½ÓÊý¾Ý¿âÒì³£

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 32 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccesso ......

mysql²éѯÓï¾ä

±ítb1£¬ÓÐ×ֶΣº

ÐòÁкÅ1  ÃèÊö  ²úÆ·µ¥ºÅ
0001    AAA     
0002    BBB
0003    CCC
1000    ²úÆ·      1   

±ítb2£¬ÓÐ×ֶΣº
²úÆ·µ¥ºÅ  ÐòÁкÅ1  ÐòÁкÅ2
1    &nb ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [95] [96] [97] [98] 99 [100] [101] [102] [103] [104]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ