ÇëÎÊÒ»ÏÂORACLEµÄÎȶ¨ÐÔºÍMYSQLÏà±ÈÈçºÎ£¿
ÒÔǰʹÓÃMysqlÊÂÎñÒýÇæINNODBÊ±Ôø¾³öÏÖ¹ýÕâÖÖÊÂÇ飬µ±Í»È»¶Ïµç»òÕßϵͳ¹ÊÕÏå´»úµÈ£¬Ôì³ÉÊý¾Ý¿â³öÎÊÌ⣬±íÎÞ·¨´ò¿ª¡£µ«ÊÇʹÓ÷ÇÊÂÎñÒýÇæmyiasm´ÓÀ´Ò²Ã»³öÏÖ¹ýÎÊÌâ¡£
ORACLEÔÚÕâ·½ÃæÎȶ¨ÐÔÈçºÎ?»á²»»áÒòΪÕâЩÎÊÌâµ¼ÖÂÊý¾Ý¶ªÊ§?
¶ÔÓÚͻȻ¶ÏµçºÍϵͳ¹ÊÕÏå´»úµÄÇé¿ö,OracleÒѾ×öÁ˺ܺõĴ¦Àí,OracleÓÐÒ»¸ö¹Ø±ÕÊý¾Ý¿âµÄsqlplusÃüÁî
SQL>shutdown abort
»áÁ¢¿Ì½«Êý¾Ý¿â¹Ø±Õ£¬µÈͬÓڶϵ硣ÕâʱÒѾcommitµÄÊÂÎñÒѾ¼Ç¼µ½online redo logÖУ¬ÏÂ´ÎÆô¶¯Êý¾Ý¿âʱ£¬Oracle½øÐÐÀý³Ì»Ö¸´²Ù×÷£¬½«online redo logÖеÄÊÂÎñ²Ù×÷µ÷ÈëÄÚ´æÖУ¬½øÐÐÏàÓ¦²Ù×÷ºó½«Êý¾Ý¼ÇÈëµ½Êý¾ÝÎļþÖУ¬Êý¾Ý²Ù×÷Íê³É¡£¶ÔÓÚûÓÐcommit¶øÒѾдÈëÊý¾ÝÎļþ»ò»ØÍ˶εÄÊý¾Ý£¬Ò²Òª½øÐÐǰ¹ö²Ù×÷£¬½«Êý¾Ý»Ö¸´µ½rollbackµÄ״̬¡£
×ÜÖ®£¬Êý¾Ý¿âÏ´δò¿ªÊ±»áÕ¼ÓñÈÕý³£¹Ø±Õ¸ü³¤µÄʱ¼ä¡£
up. Oracle µÄÎȶ¨ÐԿ϶¨±ÈMYSQLÒªºÃ.
------------------------------------------------------------------------------
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......