Ò»¸ö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'
£¬ Õâ¸ö±êµã´íÁË
×Ö·ûÐÍ ²»ÄܱȽϰÉ
Èç¹ûÊý¾ÝÄÚÈÝ·ûºÏÈÕÆÚ¸ñʽ£¬»á×Ô¶
Ïà¹ØÎÊ´ð£º
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÓÐÁ½¸ö»òÒÔÉϵÄÔ¶³ÌÊý¾Ý¿â£¬ÈçºÎÓÃASP¼ì²âÁ¬½ÓËٶȲ¢Á¬½Ó×î¿ìµÄMSSQLÊý¾Ý¿â£¿
ÓÐÕâÑùµÄASPº¯ÊýÂð£¿ÎÒGOOGLEÁËһϣ¬ÕÒ²»µ½¡£
PHP+MYSQLÏÂÓÐÕâÖÖÀý×Ó£º
PHP code:
Example:
$wgDBservers = array(
......