SQL SeverºÍMySql - MS-SQL Server / »ù´¡Àà
sql serverµÄmdfÎļþÈçºÎÄܵ¼Èëµ½mysqlÖУ¬ÎÒÏëÁ˽âһϣ¬Ï£ÍûÅóÓÑÃǰïæ
·þÎñÆ÷Á¬½Ó,Ö±½Óµ¼ÈëÊý¾Ý
ÄÜ˵¾ßÌåµãÂ𣿱¾È˸սӴ¥£¬²»ÔõôÃ÷°×£¬Ð»Ð»ÁË
Ïȸ½¼ÓÔÚSQLºó£¬È»ºóÔٲο¼ÒÔÏÂ×ÊÁÏ£º
¡¡¡¡´Ósqlµ¼³öµ½mysqlµÄ·½·¨ºÜ¶à£¬ÏÖ½éÉÜÒ»ÖÖÎÞÐè±à³Ì£¬Ö±½ÓÀûÓÃsqlºÍmysqlÀïµÄͼÐνçÃæ½øÐе¼Èëµ¼³öµÄ¼òµ¥·½·¨¡£
¡¡¡¡¡¡¡¡
¡¡¡¡Ç°ÌáÊÇÒѾ°²×°ÁËsqlserver¿Í»§¶ËºÍmysqlµÄͼÐνçÃæ¹ÜÀí¹¤¾ßphpmyadmin¡£
¡¡¡¡¡¡¡¡
¡¡¡¡ÔÚ¿ØÖÆÌ¨¸ùĿ¼Ï´ò¿ªsqlserverÆóÒµ¹ÜÀíÆ÷£¬Ð½¨sqlserver×飬¸ù¾Ý×Ô¼ºµÄÇé¿ö½øÐÐÑ¡Ôñ£»È»ºóн¨sqlserver ×¢²á£¬½øÐжÔsqlserverµÄÁ¬½Ó¡£×¼±¸Í×µ±ºó£¬ÏÂÃæ¾Í¿ªÊ¼ÁË£º
¡¡¡¡¡¡¡¡
¡¡¡¡Ê×ÏÈ´ò¿ªÊý¾Ýת»»·þÎñ£¬Ð½¨°ü£¬´ò¿ªDTS½çÃæ£¬ÔÚÁ¬½ÓÖÐÑ¡ÔñÊý¾ÝÔ´½øÐÐÅäÖá£ÔÙÑ¡Ôñ½«Òª×ª»»µ½µÄÄ¿µÄÎļþ£¬ÕâÀïÎÒÑ¡µÄ Textfile(destination)£¬Ñ¡ÔñºÃÎļþµÄ´æ·ÅλÖÃÖ®ºó£¬ÎÒÃÇÀ´Ð½¨Ò»¸öÈÎÎñ¡£ÕâÀïÎÒÃÇֻѡÔñת»»Êý¾ÝÈÎÎñ£¬½«´øÓС°Ñ¡ÔñÔ´Á¬½Ó¡±¡°Ñ¡ÔñÄ¿µÄÁ¬½Ó¡±µÄÊó±ê·Ö±ðÑ¡ÖÐÊý¾ÝÔ´ºÍÄ¿µÄÖ®ºó£¬ÎÒÃǶÔÐÂÉú³ÉµÄÁ¬½Ó½øÐж¨Ò壬ÔÚÆäÊôÐÔÖн«Ô´£¬Ä¿µÄ£¬×ª»»ÒÀ´Î¶¨Òå¡£
¡¡¡¡
¡¡¡¡Ö´ÐÐÈÎÎñ£¬Ìáʾ³É¹¦¡£±£´æÈÎÎñ¡£È»ºóÔÚн¨µÄÈÎÎñÉϵ¼³öÊý¾Ý£¬ÓÐÏòµ¼Ìáʾ£¬ÆäÖÐÒ»ÏîÑ¡Ôñ¡°´ÓÔ´Êý¾Ý¿â¸´ÖƱíºÍÊÓͼ¡±¡£
¡¡¡¡
¡¡¡¡ÕâÒ»²½ÒѾ°ÑÊý¾Ýµ¼³öµ½Ä¿µÄÎļþÖС£
¡¡¡¡¡¡¡¡
¡¡¡¡ÏÂÒ»²½ÔÚmysqlÖÐн¨±í£¬Ó뽫Ҫµ¼ÈëµÄ½á¹¹±£³ÖÒ»ÖÂʱ£¬Ö±½Óѡȡ¡°´ÓÎı¾ÎļþÖÐÌáÈ¡Êý¾Ý£¬²åÈëµ½Êý¾Ý±í£º¡±£¬½«Ñ¡ÏîÌíºÃºó£¬¡°·¢ËÍ¡±¾Í¿ÉÒÔÁË£¬ä¯ÀÀһϣ¬Êý¾ÝÒѵ¼ÈëÁË¡£ÈôÒªµ¼ÈëµÄ±íÒѾ´æÔÚ£¬ÇÒÊôÐÔÃûÒ²²»Í¬£¬Õâʱ¾ÍÏȽ¨Ò»¸öÓëÒªµ¼ÈëµÄÊý¾ÝÏàͬ½á¹¹µÄ±í²¢µ¼ÈëÊý¾Ý£¨°´¸Õ²ÅµÄ½øÐоͿÉÒÔÁË£©£¬È»ºóÔÚmysqlÖе¼³ö¡°Êý¾ÝºÍ½á¹¹¡±£¬µÃµ½sqlÓï¾
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......