sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ö¶«¶«,WPS?
ѧдÎÚ¹ê
UCDOS°É
ºÃÏóÊÇ.Íü¼ÇÁË,Ê®¶àÄêǰµÄ¶«Î÷ÁË.
ÍÛ,ÄÇʱºòÎÒʲô¶¼»¹²»¶®ÄØ
³Ô·¹,Äã»á°É?
ÎÚ¹ê´óÏÀ,°ïæ½âÊÍÏÂ,ÕûÁËÒ»ÌìÁËÄǸö,ºÃ²»ÈÝÒ×ÓеãÍ·Ð÷,ÏÖÔÚÓÖÔÎÁË
Ì«·Ñʱ¼ä,ÍíÉÏÎÒ°ïÄã¿´¿´.
ллÎÚ¹ê´óÏÀ,Äǽ«ÊÇÒ»±ÊÊÕ»ñ
Äã·¢¸ö0·ÖÌû,×îºÃÊǰѾßÌåµÄÐèÇóºÍÄÚÈÝÒÔ¼°ÆäËûÈËдµÄÄãÈÏΪÓмÛÖµµÄ¶«Î÷д³öÀ´.
{{
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖØ¸´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£Íûȡһ¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд
£º ......
±ía(ûÓÐÖ÷¼ü)
id name age
----------- ---------- -----------
1 chenqin& ......