Ò»¸öSQL Óï¾ä£¿
±¾ÈËÒª²éѯij¸öʱ¼ä¶ÎµÄÊý¾Ý
±íµÄ½á¹¹ÈçÏ£ºÊ±¼äµã ÊýÖµ1
ʱ¼äµãÊÇ×Ö·ûÐÍ
2010-02-25 10:23:25.967 23.432
2010-02-25 10:23:26.967 23.439
2010-02-25 10:23:27.967 23.482
2010-02-25 10:23:28.967 23.432
2010-02-25 10:23:29.967 23.332
2010-02-25 10:23:30.967 23.432
2010-02-25 10:23:31.967 23.400
select cast(²É¼¯µÄʱ¼äµã as datetime) AS ASDF£¬ÊýÖµ
from ²âÊÔ±í2010Äê02ÔÂ25ÈÕ
where 2010-02-05 10:23:25 967 <cast(²É¼¯µÄʱ¼äµã as datetime)
±¨´í £¿
SQL code:
select ²É¼¯µÄʱ¼äµã AS ASDF£¬ÊýÖµ from [²âÊÔ±í2010Äê02ÔÂ25ÈÕ]
where ²É¼¯µÄʱ¼äµã>'2010-02-05 10:23:25 967'
£¬ Õâ¸ö±êµã´íÁË
×Ö·ûÐÍ ²»ÄܱȽϰÉ
Èç¹ûÊý¾ÝÄÚÈÝ·ûºÏÈÕÆÚ¸ñʽ£¬»á×Ô¶
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
ÓÐÁ½¸ö»òÒÔÉϵÄÔ¶³ÌÊý¾Ý¿â£¬ÈçºÎÓÃASP¼ì²âÁ¬½ÓËٶȲ¢Á¬½Ó×î¿ìµÄMSSQLÊý¾Ý¿â£¿
ÓÐÕâÑùµÄASPº¯ÊýÂð£¿ÎÒGOOGLEÁËһϣ¬ÕÒ²»µ½¡£
PHP+MYSQLÏÂÓÐÕâÖÖÀý×Ó£º
PHP code:
Example:
$wgDBservers = array(
......