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

Ò»¸öÁ¬½Ó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


Ïà¹ØÎÊ´ð£º

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

ΪʲôMySQL²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì² ......

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ