mysqlµ¼Èëµ½sql server2000ÎÊÌâ
¿Í»§ÒÔǰµÄÊý¾Ý¿âΪmysql ÏÖÔÚеÄϵͳÓõÄÊÇsql server 2000 ¿Í»§Ö»¸øÁËmysql µ¼³öµÄ ".sql"Îļþ.ÎÒ¸ÃÈçºÎ°ÑËüµ¼Èëµ½sql server 2000
Ö»Óнű¾Îļþ??ÄÇ»¹ÊÇ×°¸öMYSQL È»ºóµ¼Èëµ½MYSQLÖÐ ÔÙÓÃSQL SERVERµÄDTSÀ´½â¾öÒýÓà ¿Í»§ÒÔǰµÄÊý¾Ý¿âΪmysql ÏÖÔÚеÄϵͳÓõÄÊÇsql server 2000 ¿Í»§Ö»¸øÁËmysql µ¼³öµÄ ".sql"Îļþ.ÎÒ¸ÃÈçºÎ°ÑËüµ¼Èëµ½sql server 2000 ¿Í»§Èç¹û¸øÄãµÄÊÇmysql Éú³ÉµÄmssqlÎļþ¾ÍºÃ°ìÁË£¬Èç¹û²»ÊÇ£¬¾Í±¾ßÁËÒýÓà ֻÓнű¾Îļþ??ÄÇ»¹ÊÇ×°¸öMYSQL È»ºóµ¼Èëµ½MYSQLÖÐ ÔÙÓÃSQL SERVERµÄDTSÀ´½â¾ö sql server 2000µÄdtsÈçºÎ²Ù×÷ѽ.ÎÒÔõôûÓÐÕÒµ½mysql ÕâÒ»Ïî ÎÒµÄsqlÖ»µÄ¶ÔoracleµÄoledb.ÔõôûÓжÔmysqlµÄ?Äܲ»ÄÜÔÙÖ¸½ÌÒ»ÏÂѽ.¸ßÈË! ллСF¿ÉÎÒ»¹ÊÇsql server2000
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
µÚÒ»¾ä: select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je from ht left join gfdm on ht.gfdm=gfdm.gfdm join jh on ht.htbh=jh.hth and ht.htbh not like'del%' and ht. ......