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

´´½¨oracle·ÃÎÊmysqlµÄÊý¾ÝÁ´Â·²½Öè

(1)µÇ½µ½mysql
C:\Documents and Settings\Administrator>mysql -h localhost -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 69
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
(2)´´½¨Êý¾Ý¿â
mysql> create database oracle;
Query OK, 1 row affected (0.00 sec)
(3)´´½¨±»·ÃÎʵÄmysqlÓû§
mysql> grant all privileges on oracle.* to 'orauser'@'%' identified by 'orauser'
with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
(4)µÇ½¸ÃÓû§£¬²¢²âÊÔ
C:\Documents and Settings\Administrator>mysql -h localhost -u orauser -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 70
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use oracle;
Database changed
mysql> create table test(tid integer,tname varchar(20));
Query OK, 0 rows affected (0.06 sec)
mysql> insert into test(tid,tname)values(1,'byf');
Query OK, 1 row affected (0.03 sec)
mysql> insert into test(tid,tname)values(2,'others');
Query OK, 1 row affected (0.02 sec)
mysql> select * from test;
+------+--------+
| tid | tname |
+------+--------+
|    1 | byf    |
|    2 | others |
+------+--------+
2 rows in set (0.00 sec)
mysql>
(5)°²×°mysql odbc driver 3.51²¢ÉèÖÃodbcÊý¾ÝÔ´
data source name:mysqlora
server:localhost
user: orauser
password:orauser
database:oracle
(6)ÅäÖóõʼ»¯²ÎÊý%ORACLE_HOME%/admin/initmysqlora.ora
HS_FDS_CONNECT_INFO =mysqlora
HS_FDS_TRACE_LEVEL = on
(7)ÅäÖÃ%ORACLE_HOME%/newtwork/admin/tnsname.ora
mysqlora=
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  &nb


Ïà¹ØÎĵµ£º

oracleÊý¾Ý¿âÐ¶ÔØ²½Öè

Ð¶ÔØOracle £º
1¡¢Í£Ö¹ËùÓÐOracle·þÎñ£¬µãUniversal InstallerÐ¶ÔØ
2¡¢É¾³ý×¢²á±íÖеÄËùÓйØÓÚOracleÏî
£¨1£©ÔÚHKEY_LOCAL_MACHINE\SOFTWAREÏ£¬É¾³ýOracleĿ¼
£¨2£©ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\ServicesÏ£¬É¾³ýËùÓÐOracleÏî
£¨3£©ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\ServicesÏ£¬É¾³ýË ......

oracle·ÖÒ³

racle·ÖÒ³²éѯÓï¾ä
ĬÈÏ·ÖÀà   2009-12-23 18:17   ÔĶÁ43   ÆÀÂÛ0   ×ֺţº ´ó´ó  ÖÐÖР СС Oracle·ÖÒ³²éѯÓï¾ä
±¾ÎÄ×ªÔØ×Ô£ºyangtingkun.itpub.net/post/468/100278
OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
·ÖÒ³²éѯ¸ñʽ£º
sql ´úÂë ......

±àдOracle°üÖеĺ¯ÊýÓ¦µ±×¢ÒâµÄÁ½µãÎÊÌâ

×Ô¼º¸Õ¿ªÊ¼ÓÃPL/SQLÀ´Ð´Ò»µã¶«Î÷£¬ÏÖÔÚ»¹·ôdzµÄºÜ£¬ËµÕâЩ²»ÊÇÏëÇ«Ð飬¶øÊÇÏëÈç¹ûÓиßÊÖ¿´µ½×Ô¼ºÓÐʲôµØ·½Ð´´íµÄ£¬Ï£Íû¸øÎÒÒ»µãÖ¸µã¡£
½ñÌìÏÂÎçÕÒÁËÒ»ÏÂÎç×Ô¼ºµÄÄǸöPL/SQL°üµÄ´íÎó£¬×îºó»¹Êǽâ¾öÁË¡£¡£¡£Á½¸öСµÄ²»ÄÜÔÙСµÄÎÊÌ⣬ºÍ´ó¼Ò·ÖÏíһϡ£
1¡¢ÔÚPL/SQLÖÐÈç¹ûÊǺ¯Êý£¬¾Í¿ÉÒÔSQLÓï¾äÖÐʹÓã¬Ò²¿ÉÒÔÔÚÆäËûµÄPL/SQL ......

mysql´æ´¢ÒýÇæÖ® InnoDB

InnoDB¸ÅÊö
InnoDB¸øMySQLÌṩÁ˾ßÓÐÌá½»£¬»Ø¹öºÍ±ÀÀ£»Ö¸´ÄÜÁ¦µÄÊÂÎñ°²È«£¨ACID¼æÈÝ£©´æ´¢ÒýÇæ¡£InnoDBËø¶¨ÔÚÐм¶²¢ÇÒÒ²ÔÚSELECTÓï¾äÌṩһ¸öOracle·ç¸ñÒ»ÖµķÇËø¶¨¶Á¡£ÕâÐ©ÌØÉ«Ôö¼ÓÁ˶àÓû§²¿ÊðºÍÐÔÄÜ¡£Ã»ÓÐÔÚInnoDBÖÐÀ©´óËø¶¨µÄÐèÒª£¬ÒòΪÔÚInnoDBÖÐÐм¶Ëø¶¨ÊʺϷdz£Ð¡µÄ¿Õ¼ä¡£InnoDBÒ²Ö§³ÖFOREIGN KEYÇ¿ÖÆ¡£ÔÚSQL²éÑ¯Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ