Ò»¸öÁ¬½Ó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
Ïà¹ØÎÊ´ð£º
ÎÒ¿ª·¢ASP.netʱ ²åÈëÍâÎÄÂÒÂë SHOW VARIABLES LIKE 'character%'; Õâ¸öʱºò character_set_client utf8 character_set_connection utf8 character_set_database utf8 ch ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂ𣿠create table publishers ( publisherID int identity, publisherName varchar (30) NOT NULL, constraint pk_publishers primary key (publisherID) )& ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......