ÈçºÎ°ÑmysqlÀïµÄÊý¾Ýµ¼Èëµ½sqlserverÀ
ÎÒÏë°ÑmysqlÀïµÄusers±íÀïÊý¾Ýµ¼Èëµ½sqlserverÀïµÄfs_me_users±íÀï
ÀïÃæµÄ×ֶξͲ»ÁгöÀ´ÁË ÊǶÔÓ¦µÃ¡£
ÓÃasp asp.net »òÕß Ö±½ÓsqlÓï¾ä¶¼ÐÐ
Çë½Ì¸÷λ¡£¡£¡£¡££¡
Õâ¸ö²»ÄѰÉ
1. asp.net µÄ»°,¶ÁÈ¡mysqlµÄ¼Ç¼¼¯,È»ºóÑ»·²åÈëmssql¾Í¿ÉÒÔÁË, mysqlÓÐado.netµÄÇý¶¯
2. »òÕßÓÃODBCÊý¾ÝÔ´, ÔÚmssqlÆóÒµ¹ÜÀíÆ÷ÉÏÊÖ¹¤µ¼Èë
ÎÒÒÔǰÊÇÏȵ¼µ½accessÀÔÙ´ÓmssqlÀïµ¼ÈëÊý¾Ý£¬Ñ¡ÔñÕâ¸öaccessÎļþ¡£
mysqlµ¼µ½accessÀï²»Éٲ鿴mysqlµÄ¹¤¾ßÖ±½Ó´øÕ⹦ÄÜ
ÕâÀïµÄÈ˶¼ÊǸßÊÖ°¡£¬ÎÒÂäºóà¶£¬°¥
ËäÈ»²»ÊÇJAVASCRIPTµÄÎÊÌâ
ÔÚ֮ǰҲÓöµ½ÀàËÆµÄÎÊÌâ Çé¿öÊǹ«Ë¾µÄERPÊý¾Ý¿âÊÇSQL SERVERµÄ ¹«Ë¾ÍøÕ¾¾ÓÈ»ÓÃÁ˸öSHOPEX ÊÇMYSQLµÄÊý¾Ý¿â£¬Á½ÕßÖ®¼äÉÌÆ·Êý¾ÝÐèҪͬ²½ Ò²¾ÍÊÇSQL SERVERµÄÊý¾ÝÐèÒªµ¼Èëµ½MYSQL ûÓа²×°ODBCÏÂMYSQLµÄÇý¶¯ ×Ô¼ºÐ´¸öVBÏȰÑÐèÒªµÄÊý¾Ý´ÓSQL SERVERÖе¼³öµ½Îı¾Îļþ£¬È»ºóÔÚд¸öPHP³ÌÐòÖ±½Ó¶ÁÈëMYSQL
°¥ ²»¹ýͦÂé·³µÄ ²»½¨ÒéÕâÑù×ö ºÇºÇ¡£
ÓÃexcelµ¼Â¶à·½±ãµÄ
¶¥Ò»Â¥µÄ¡£¡£¡£¡£...................
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......