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

OracleÓëMySQLÖС°¿É´®Ðл¯¡±µÄ¶Ô±È²âÊÔ

OracleÓëMySQLÖГ¿É´®Ðл¯”µÄ¶Ô±È²âÊÔ
      Thomas Kyte ÔÚ“Oracle 9i&10g±à³ÌÒÕÊõ”Ò»ÊéÖÐΪÁË˵Ã÷ÊÂÎñµÄ¸ôÀë¼¶±ð£¬ÌṩÁËһЩÀý×Ó¡£ÕâÀïÎÒÃÇÀ´¿´¿´“¿É´®Ðл¯”¼¶±ðϵıíÏÖ¡£
ÒÔÆÕͨÓû§µÇ¼ϵͳ£¬²¢´´½¨²âÊÔÓÃµÄ±í¡£
idle> connect scott/tiger
Connected.
scott@FOO> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0    Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
scott@FOO> create table a(x int);
Table created.
scott@FOO> create table b(x int);
Table created.
ÐÞ¸ÄÊÂÎñµÄ¸ôÀë¼¶±ðΪ“¿É´®Ðл¯”
ʱ¿Ì »á»°1                                                                          »á»°2
t1     scott@FOO> alter session set isolation_level = serializable;
       Session altered.
t2                                                                                      scott@FOO> alter session set isolation_level = serializable;
               


Ïà¹ØÎĵµ£º

[ÍÆ¼ö] Éî¶È¶Ô±ÈOracleÓëSQL Server [1]

±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊðÃû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉЭÒé·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºSadequl Hussain | Ô­ÎÄ£ºhttp://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx
Ò» ......

PHPÁ¬½ÓMYSQLÊý¾Ý¿â

<p>04¼¶ÐÂÉúÃûµ¥</p>
<table border="1" width="80%" cellpadding="0">
<tr>
<td width="10%" align="center">Id</td>
<td width="20%" align="center">Name</td>
<td width="10%" align="center">Age</td>
<td width="10%" align="cent ......

UbuntuÏÂÅäÖÃLAMP£¨Linux+Apache+Mysql+PHP)»·¾³

ÖÕÓڷżÙÁË£¬ÕýÏëÔÚÕâ¸ö¼ÙÆÚÀïѧѧPHP£¬ÓÉÓÚ×Ô¼ºÓõÄÊÇ×ÀÃæ°æµÄUbuntu8.04,ÓÚÊǾÍÏë¼ÜÉèÒ»¸öLAMP»·¾³À´Ñ§PHP£¬Ò²³Ã´Ë»ú»áѧһÏÂPHP·þÎñÆ÷µÄ¼ÜÉè¡£
Ò»¡¢°²×°Ubuntu8.04
ËäȻ˵ÊÇÅäÖÃLAMP»·¾³£¬µ«ÔÚÎÄÕÂÀï²¢²»»á½²ÊöÈçºÎ°²×°Ubuntu8.04,ÒòΪ¹ØÓÚÈçºÎUbuntu8.04ÔÚÍøÉÏÒѾ­ÓкܶàµÄ½Ì³ÌÁË£¬¾ÍËãÊÇÓ²Å̰²×°Ò²ÊÇÒ»¼þºÜ¼òµ¥µÄÊÂÁ ......

mysql dataÎļþ¼ÐϵÄibdata1 Îļþ×÷ÓÃ


Õâ¸öÎļþ³¬¼¶´ó£¬ ²éÁËһϣ¬ ´ó¸ÅµÄ×÷ÓÃÈçÏÂ
ÊÇ´¢´æµÄ¸ñʽ
INNODBÀàÐÍÊý¾Ý״̬Ï£¬
ibdataÓÃÀ´´¢´æÎļþµÄÊý¾Ý
¶ø¿âÃûµÄÎļþ¼ÐÀïÃæµÄÄÇЩ±íÎļþÖ»Êǽṹ¶øÒÑ
ÓÉÓÚmysql4.1ĬÈÏÊÔinnodb£¬ËùÒÔÕâ¸öÎļþĬÈϾʹæÔÚÁËhttp://man.chinaunix.net/database/mysql/inonodb_zh/2.htm Õâ¸öÁ´½ÓÊÔinnodbµÄÖÐÎIJο¼£¬ innodbµÄ¶« ......

Mysql Explain Ïê½â

Òý×Ô http://www.itpub.net/thread-1034410-1-1.html
Mysql Explain Ïê½â
Ò».Óï·¨
explain < table_name >
ÀýÈç: explain select * from t3 where id=3952602;
¶þ.explainÊä³ö½âÊÍ
+----+-------------+-------+-------+-------------------+---------+---------+-------+------+-------+
| id | select_type ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ