±íÃû:ABC
select * from abc ÌáʾÕÒ²»µ½¶ÔÏó
select * from ABC ÕýÈ·.
Õâ¸ö´óСдÔÚÄÄÀïÉèÖõÄ?
ÒÔǰ½¨µÄ¿âµ¹Ã»Õâ¸öÎÊÌâ.ºóÔÚ±¾ÉíÖØÐ½¨Á¢Ò»Ð¿â.ÓÉÓÚ³ÌÐòÖлù±¾ÉÏȫΪСд.³ÌÐòÎÞ·¨ÔËÐÐ.È«ÊÇ´íÎóÌáʾ.ÕÒ²»µ½¸Ã¶ÔÏó.
ÐÞ¸ÄÅÅÐò¹æÔò
¶¥
ÅÅÐò¹æÔò³£見問題Õû體 ......
ÏÂÃæµÄÈÕÆÚÎÒÒªÓñäÁ¿±íʾ
µ«ÎÒ½ÓÊÕµÄÈÕÆÚµÄ¸ñʽÓëÏÂÃæ²»Í¬
ÎÒ½ÓÊÕµÄÈç 2009-10-10
ÎÒÓ¦¸ÃÔõô±äÄØ£¿
ÿ´Î¶¼°Ñ date1 ºÍdate2ÓÃString ÕâÑùÊDz»ÊDz»ºÃ
SQL code:
between '" + date1 + "' nad '" + date2 + "'
SQL code:
insert into hwouttb3
select * ......
ÒÔǰÔÚѧУѧµÄÊDZʼǻù´¡µÄ½Ì³Ì
ÏëÂò±¾sql 2005·½ÃæµÄÊéÏ£ÍûÉÏÃæÀýÌâ±È½Ï¶à£¬½²µÄÄÜÏêϸµã
֪ʶµãҪȫ
ÎÒÒ²ÏëÖªµÀ.
ÖåÀÏ´óµÄÊé
jf
Áº¸çÄãÄÇôţ¶¼ÄܳöÊéÁË¡£¡£¡£
ÉîÈëdz³öSQL 2005¿ª·¢¡¢¹ÜÀíÓëÓ¦ÓÃʵÀý
http://product.dangdang.com/product.aspx?product_id=20228858
Õâ±¾ÊéÈçºÎ°¡¡£¡£¡£
×ÞÀ ......
Êý¾Ý¿â ÏÖÔÚÓбí1£¬±í2ÈçÏ£¬ÒªÇóÊä³ö±í3µÄÑù×Ó
Table1
yue dep yj
Ò»ÔÂ 1 10
¶þÔÂ 1 20
ÈýÔÂ 2 30
Table2
dep dep_name
1 ²¿ÃÅ1
2 ² ......
¼ÙʹÓбíA ¼ÙʹÓбíB
Name Exp_Money & ......
Óиö·¿¼ä¼Û¸ñ±íRP:
id roomid price startDate endDate inputDate
1 1 1000 2009-10-1 2009-10-11 2009-10-1
2 1 800  ......