MysqlÁ¬½Óoracle
ÐèÒªÔÚMySQLÀïÃæÐ´¸ö´¢´æ¹ý³Ì,
·ÃÎÊoracleµÄÊý¾Ý.
Ŀǰ²»ÄÜ
oracle¿ÉÒԾͿÉÒÔÁ¬½Ómysql£¬Í¨¹ýodbc+dblinkÀ´Á¬½Ó
ûÓа취¡£Ä¿Ç°µÄMYSQLµÄ°æ±¾ÖÐÉв»Ö§³ÖÁ¬½Óµ½ÆäËüÊý¾Ý¿â£¬
ÕæÍ¦ÓÐÏë·¨µÄ ĿǰÎÒû×ö¹ý
Äã¿ÉÒÔ¸ÃmysqlµÄconnecter
ûÓÐÖ±½ÓµÄ°ì·¨¡£
ÔÀ´ÕâÑùÒ²¿ÉÒԵİ¡£¬·þ
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
$conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
ÎÒµÄÎÊÌâÊÇÕâÑùµÄ£º
ÔÚÊý¾Ý¿âÖÐÓÐÁ½ÕÅ±í£ºtable A,table B,
table A ÖÐÓÐ×Ö¶Î_ID,channelID,_createdBy,_status
table B ÖÐÓÐ×Ö¶Î_ID,userName,_status
AÖеÄ_createdByÊÇBÖÐ_ID,BÖеÄ_IDºÍuser ......
ΪʲôÎÒÕ³Ìù´æ´¢¹ý³Ì´úÂëµÄʱºò¡£¡£¡£Öмä³öÏÖÕâ¸öÁË¡£¡£¡£
Display all 812 possibilities? (y or n)
? & ......