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 ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
ÐèÇóÈçÏ£º
ѧԺ 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 ......