´´½¨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 £º
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Ï£¬É¾³ýË ......
racle·ÖÒ³²éѯÓï¾ä
ĬÈÏ·ÖÀà 2009-12-23 18:17 ÔĶÁ43 ÆÀÂÛ0 ×ֺţº ´ó´ó ÖÐÖРСС Oracle·ÖÒ³²éѯÓï¾ä
±¾ÎÄ×ªÔØ×Ô£ºyangtingkun.itpub.net/post/468/100278
OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
·ÖÒ³²éѯ¸ñʽ£º
sql ´úÂë
......
×Ô¼º¸Õ¿ªÊ¼ÓÃPL/SQLÀ´Ð´Ò»µã¶«Î÷£¬ÏÖÔÚ»¹·ôdzµÄºÜ£¬ËµÕâЩ²»ÊÇÏëÇ«Ð飬¶øÊÇÏëÈç¹ûÓиßÊÖ¿´µ½×Ô¼ºÓÐʲôµØ·½Ð´´íµÄ£¬Ï£Íû¸øÎÒÒ»µãÖ¸µã¡£
½ñÌìÏÂÎçÕÒÁËÒ»ÏÂÎç×Ô¼ºµÄÄǸöPL/SQL°üµÄ´íÎó£¬×îºó»¹Êǽâ¾öÁË¡£¡£¡£Á½¸öСµÄ²»ÄÜÔÙСµÄÎÊÌ⣬ºÍ´ó¼Ò·ÖÏíһϡ£
1¡¢ÔÚPL/SQLÖÐÈç¹ûÊǺ¯Êý£¬¾Í¿ÉÒÔSQLÓï¾äÖÐʹÓã¬Ò²¿ÉÒÔÔÚÆäËûµÄPL/SQL ......
InnoDB¸ÅÊö
InnoDB¸øMySQLÌṩÁ˾ßÓÐÌá½»£¬»Ø¹öºÍ±ÀÀ£»Ö¸´ÄÜÁ¦µÄÊÂÎñ°²È«£¨ACID¼æÈÝ£©´æ´¢ÒýÇæ¡£InnoDBËø¶¨ÔÚÐм¶²¢ÇÒÒ²ÔÚSELECTÓï¾äÌṩһ¸öOracle·ç¸ñÒ»ÖµķÇËø¶¨¶Á¡£ÕâÐ©ÌØÉ«Ôö¼ÓÁ˶àÓû§²¿ÊðºÍÐÔÄÜ¡£Ã»ÓÐÔÚInnoDBÖÐÀ©´óËø¶¨µÄÐèÒª£¬ÒòΪÔÚInnoDBÖÐÐм¶Ëø¶¨ÊʺϷdz£Ð¡µÄ¿Õ¼ä¡£InnoDBÒ²Ö§³ÖFOREIGN KEYÇ¿ÖÆ¡£ÔÚSQL²éÑ¯Ö ......