±¾ÈËÔÚ×öÒ»¸öÍøÕ¾ÏµÍ³µÄʱºòÒªÓõ½´æ´¢¹ý³Ì£¬ÓÉÓÚmssqlºÍmysqlµÄ´æ´¢¹ý³ÌÓï¾ä²î±ð±ð½Ï´ó£¬ÔÚÍøÉϲéÁ˺ܾÃҲûÓвé³ö¹ýËùÒÔÈ»£¬ËùÒÔÇóÒ»¸ömysqlµÄ´æ´¢¹ý³ÌÓï¾ä¡£ÒªÇóÈçÏ£º
ÎÒ´´½¨ÁËÒ»¸öÊý¾Ý¿âµÄÊÓͼ£¬´´½¨Ò»¸ö´æ´¢¹ý³ÌÒªÓõ½ÊÓͼÖеIJéѯ×ֶΡ£
ÊÓͼ´úÂëÈçÏ£º
-- ----------------------------
-- View st ......
ÎÒÓõÄÊÇMySQLDriverCSµÄ½Ó¿Ú£¬ÍøÉϵĻù±¾Á¬½Ó·½·¨Ò²»á£¬µ«ÊÇÎÒµÄÐèÇóÊÇÒªÔÚδ֪Êý¾Ý¿âÃûµÄÇé¿öÏ£¬ÒÑÖªlocalhost£¬Óû§Ãû£¬ÃÜÂ룬Á¬½ÓÉÏÊý¾Ý¿â²¢»ñÈ¡MySQLÏÖÓеÄÊý¾Ý¿âÃû¡£ÇëÖªµÀµÄ¸ßÊÖ³öÀ´»Ø´ðһϰɣ¡Ð¡µÜÏÈллÄãÃÇÁË£¡
×Ô¼ºÏȶ¥Ò»Ï£¬Ï£Íû¸ßÊÖ³öÀ´»Ø´ð£¡£¡
Ôõô¶¼Ã»Æð´²Âð£¿
ΪʲôûÈËÀíÎÒ°¡£¡£¡£¡£¡
°ï¶¥£ ......
Ìṩһ¸öÍêÕûµÄ¼òµ¥Ê¾Àý
µã»÷×¢²áµÄʱºò£¬°ÑÐÅϢͬʱע²áµ½mysqlµÄA±íºÍmssqlµÄA±í лл
×¢²á¹¦ÄÜ?? ÊÇʲôÒâ˼
ÒýÓÃ
PHP code//Á¬½Ómysql$insertmysql="insert into A values('$name','$pass')";mysql_query($insertmysql);//Á¬½Ómssql$insertmssql="insert into A values( ......
mysqlÊý¾Ý¿âÖеÄlongtext×Ö¶ÎÀàÐÍÔõôÓ𡣿³¤¶ÈÓÃÉèÖÃÂð£¿ÎÒÉèÖÃÁ˳¤¶È±£´æÊ±Ò²»á±ä³É0£¬Ö´ÐÐÌí¼Ó¼Ç¼²Ù×÷ʱ£¬Õâ¸ö×ֶβ»ÄÜдÈ룬лл¸÷λÀ²£¬µÚÒ»´ÎÓÃ
LONGTEXT
Ò»¸öBLOB»òTEXTÁУ¬×î´ó³¤¶ÈΪ4294967295(2^32-1)¸ö×Ö·û¡£
²»ÓÃÉ賤¶È£¬Êµ¼ÊÉϾ͵±CLOB¾ÍÐÐÁË
°ï¶¥
......
1.
ÏÖÔÚÓÐÕâÑùÒ»¸öÊý¾Ý±ístudent
name object score
a EN 89
a CH 78
a HO 99
b EN 34
b CH 88
b HO 66
ÒªÇóÉú³ÉÏÂÃæÑùʽ
name EN CH HO
a 89 78 99
b 34 88 66
2.
±íÒ»
ѧÉú±àºÅ ѧÉúÐÕÃû ¿Æ±ð ·ÖÊý
1083 ÕÅÈý ÓïÎÄ 75
1083 ÕÅÈý Êýѧ 84 ......
mssqlµÄÆóÒµ¹ÜÀíÆ÷ÖÐÌí¼ÓmysqlµÄÁ´½Ó·þÎñÆ÷Ôõô²Ù×÷£¬ÎÒÏëÓÃÆóÒµ¹ÜÀíµÄÃæ°åʵÏÖ£¬²»Òª´úÂëÐÎʽµÄ¡£Ïêϸ¹ý³Ì£¬ËÄÜ˵˵Â
ÒýÓÃ
Ö±½ÓÌîдÄãµÄ·þÎñÆ÷µØÖ·£¬¶Ë¿ÚºÅ£¬Õ˺ż°ÃÜÂë¾Í¿ÉÒÔÁË¡£
ÄãÕâÑù˵ºÍÃ»ËµÃ»É¶Çø±ð£¬ÎÒ×Ô¼º²éµ½ÁË¡£
......