mssqlתmysql
ÎÒµÄÒ»°Ù¶àÍòÊý¾ÝÄÚ´æÏûºÄÌ«´óÁË Á½Ìì²»ÖØÆôsql·þÎñÖ±½Ó±Ä3GÁË ÎÒ·þÎñÆ÷×ܹ²²Å4G ²»ÄÜÈÃËûÕâôÕÛÌÚ¡£
mysqlÖ§³Ö·ÖÇøÂ𣿣¿£¿
ÓÐʲôÈí¼þ¿ÉÒÔ±ã½ÝµÄ°Ñmssql2005Êý¾Ý¿âתµ½mysqlÀ£¿£¿Ð»Ð»´ó¼ÒÀ²~£¡£¡
MySQL Migration Toolkit (MySQL¹ÙÍøÏÂÔØ)
http://dev.mysql.com/downloads/gui-tools/5.0.html
Õâ¸ö¹¤¾ßÖ§³ÖǨÒÆ´æ´¢¹ý³ÌÂð£¿
²»»á
MySQL GUI Tools ??Äã¸øÎÒµÄÔõôÊÇ gui tools Õâ¸ö¿ÉÒÔÒÆÖ²Âð£¿
ÎÒÊǽøÀ´Ñ§Ï°µÄ¡£
ÎÒÊǽøÀ´Ñ§Ï°µÄ¡£
²»Ö§³Ö
¿´Ò»ÏÂÈí¼þ˵Ã÷¡£
Èç¹ûϵͳûÓбäÂý,ûÓбØҪת.
Èç¹ûϵͳһÌìÒ»Ìì±äÂý,ÄÇÄãµÃ¼ì²éÒ»ÏÂÄãµÄÊý¾Ý±íÊÇ·ñÓÅ»¯,²éѯÓï¾äÊÇ·ñÓÐÎÊÌâ,´æ´¢¹ý³Ì,Óû§º¯Êý µÈÉè¼ÆÊÇ·ñ´æÔÚÎÊÌâ.ÊÇ·ñÓÐËø.
Ïà¹ØÎÊ´ð£º
ƽ°²Ò¹¸øûÊÕµ½ÀñÎïµÄGG &&MM ÎÒÀ´ËÍÀñÎïÀ²¡£
ÊÕµ½ÀñÎïµÄ¾Í±ð½Ó·ÖÁË£¡ÒªÊǽӲ»µ½°Ñ×Ô¼ºµÄ³ôÍà×ÓÄóöÀ´£¬µÈÊ¥µ®ÀÏÈËÍíÉÏËÍÄã°É£¡
SF
bd
sf
À´jfµÄ
²»´©Íà×Ó
JAVA php JS MYSQL C# °æ¶¼·¢Í ......
ÔÚvbscriptÖв»ÓÃon error resume nextÈçºÎÅжÏmssqlÓï·¨´íÎó£¡
TRY CATCH?
»òÕßʹÓÃÁ÷³Ì¿ØÖÆÓï¾ä
if
else
²»ÓÃon error ÓÃÄǸöÎҾͲ»ÐèÒªÔÚÕâÀïÑ°ÕÒ´ð°¸
ÒýÓÃ
²»ÓÃon error ÓÃÄǸöÎҾͲ»Ðè ......
±íµÄ½á¹¹ÈçÏ£º
±í1£ºtb_big
×ֶΣºfalseIDÖµ£º1£¬2
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseIDµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©
±í2£ºtb_small
×ֶΣºfalseID£¨Óëtb_bigµÄfalseID¹ØÁªµÄ ......
ÎÒµÄjava³ÌÐòÒªÁ¬½ÓÔ¶³ÌµÄÊý¾Ý¿âMSSQL£¬µ«ÊÇÔ¶³Ì·þÎñÆ÷£¬Ã»Óпª1433¶Ë¿Ú£¬ÓÐʲô°ì·¨ÄÜÈÃÎÒµÄjava³ÌÐòÁ¬½ÓÔ¶³ÌÊý¾Ý¿â
ÊÇ˵mysqlÂð£¿
ÎÒÒ²Óöµ½ÁËÕâ¸öÎÊÌ⣬ÎÒÒ²ÏëÇó½â¾ö£¬ºÇºÇ£¬°ïÄ㶥¶¥£¡
MSSQL,¾ÍÊÇ΢Èí ......
Ò»ÕÅ±í£¬×ֶηÖΪid,time1,time2,time3,time4,time5
ÇëÎÊÎÒÓ¦¸ÃÈçºÎÑ¡ÔñIDΪ1µÄÄÇÌõ¼Ç¼ÖÐtimeʱ¼ä×îСµÄÖµÄØ£¿
UP!
[code=SQL][/code]select min(t) from
(select time1 as t from t1 where id ......