Ò»¸öÁ¬½ÓmysqlºÍmssqlµÄ×¢²á¹¦ÄÜ£¡100·Ö
Ìṩһ¸öÍêÕûµÄ¼òµ¥Ê¾Àý µã»÷×¢²áµÄʱºò£¬°ÑÐÅϢͬʱע²áµ½mysqlµÄA±íºÍmssqlµÄA±í лл
×¢²á¹¦ÄÜ?? ÊÇʲôÒâ˼ÒýÓà PHP code//Á¬½Ómysql$insertmysql="insert into A values('$name','$pass')";mysql_query($insertmysql);//Á¬½Ómssql$insertmssql="insert into A values('$name','$pass')"; mssql_query($insermssql); ÄãºÃ ÎÒÊǵÚÒ»´Î½Ó´¥PHP£¬¿ÉÒÔÏêϸµãÂð ÆäʵÎÒÊÇÏëÔÚDiscuzÀïµÄ×¢²áÌí¼ÓÒ»¸öµ½MSSQLµÄ±í $db->query("Insert Into ceshi(CeshiName)Values('AAAA')"); Õâ¸öÊÇÎÒ²âÊÔÁËÏÂÔÚMYSQLÀïOK ÏÖÔÚÎÒÏëÔõôʵÏÖÔÚMSSQL£¬mysql_queryÕâ¸öÊÇʲô£¿ÎÒÐèÒªÁ¬½ÓÊý¾Ý¿âÊÇÔõôÑùµÄ ³õѧÕßÇë½ÌºÇºÇ ¼ÈÈ»ÊÇÐÂÊÖ£¬½¨ÒéÏÈ¿´¿´PHPÊÖ²áÔÙȥʵÏÖijЩ¹¦ÄÜ¡£ÒýÓà ¼ÈÈ»ÊÇÐÂÊÖ£¬½¨ÒéÏÈ¿´¿´PHPÊÖ²áÔÙȥʵÏÖijЩ¹¦ÄÜ¡£ ллÄãµÄ½¨Ò飬ÓÉÓÚ¸Õ½Ó´¥PHP£¬Óï·¨²»ÊìϤ£¬²»¹ý×¢²áµÄ»°Ò²¾ÍÊÇÒ»ÌõSQL ÎÒÏÖÔÚ¾ÍÊÇÏë×î¼òµ¥µÄ×¢²áµ½MSSQLÀïµÄÒ»¸öСʾÀý PHP code: <?php $con=mssql_connect("localhost","sa","123","ceshi"); echo $con; if($con) echo "<br/>Á¬½Ó³É¹¦"; else echo "Á¬½Óʧ°Ü"; ?> ±ÈÈçÕâ¸öÊý¾Ý¿âÁ¬½ÓÉÏÁË ÎÒÔõôÌí¼ÓÒ»ÌõÊý¾Ý£¿ PHP code Code highlig
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂ𣿠Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡ ²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÈçÌ⣬MySQL²»»áÕâÑù°É Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£ http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx MySQL ÖÐÎÄÏÔʾÂÒÂë Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖà ֧³Ö£¬¼ì² ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í: You can't specify target table 'a_table' for update in from clause ÍêÕûSQLÓï¾äÊÇ UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......