Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ö¶«¶«,WPS?

ѧдÎÚ¹ê

UCDOS°É


ÒýÓÃ
UCDOS°É


ºÃÏóÊÇ.Íü¼ÇÁË,Ê®¶àÄêǰµÄ¶«Î÷ÁË.

ÒýÓÃ
ÒýÓà 3 Â¥ 7761098 µÄ»Ø¸´:
UCDOS°É


ºÃÏóÊÇ.Íü¼ÇÁË,Ê®¶àÄêǰµÄ¶«Î÷ÁË.

ÍÛ,ÄÇʱºòÎÒʲô¶¼»¹²»¶®ÄØ

³Ô·¹,Äã»á°É?

ÒýÓÃ
³Ô·¹,Äã»á°É?

ÎÚ¹ê´óÏÀ,°ïæ½âÊÍÏÂ,ÕûÁËÒ»ÌìÁËÄǸö,ºÃ²»ÈÝÒ×ÓеãÍ·Ð÷,ÏÖÔÚÓÖÔÎÁË

Ì«·Ñʱ¼ä,ÍíÉÏÎÒ°ïÄã¿´¿´.

ÒýÓÃ
Ì«·Ñʱ¼ä,ÍíÉÏÎÒ°ïÄã¿´¿´.

ллÎÚ¹ê´óÏÀ,Äǽ«ÊÇÒ»±ÊÊÕ»ñ

Äã·¢¸ö0·ÖÌû,×îºÃÊǰѾßÌåµÄÐèÇóºÍÄÚÈÝÒÔ¼°ÆäËûÈËдµÄÄãÈÏΪÓмÛÖµµÄ¶«Î÷д³öÀ´.
{{


Ïà¹ØÎÊ´ð£º

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

sql²éѯÒÉÎÊ

±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖØ¸´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£Íûȡһ¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд

£º ......

ÀÏÎÊÌâ ͨ¹ýSQLÓï¾äÈçºÎɾ³ý±íÖеÄÖØ¸´¼Ç¼£¿

±ía(ûÓÐÖ÷¼ü)
id          name      age       
----------- ---------- -----------
1          chenqin& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ