ÇóÒ»ÌõÅÅÐòSQL - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
±íA
×Ö¶Î:fid,title
fid,title
1 ÕÅÈý
1 ÍõÎå
1 ÕÅËÄ
1 ÕŶþ
1 ÍõËÄ
3 ÕÅÈý·¢²¼
4 ÍõÎå·¢²¼
5 ÕÅÈý·¢²¼
6 ÕÅÈý·¢²¼2
fid=1µÄtitleÊÇÐÕÃû£¬²»µÈÓÚ1µÄtitleÊÇÐÅÏ¢ÇÒ°üº¬·¢²¼È˵ÄÐÕÃû£¬ÈçºÎÓÃSQLÁгö¸÷¸öÈ˵ķ¢²¼ÊýÁ¿µÝ¼õÅÅÐò
(²»Òª¸ß¹ÀÄãµÄººÓï±í´ïÄÜÁ¦»òÕßÎҵĺºÓïÀí½âÄÜÁ¦)
½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£
²Î¿¼Ò»ÏÂÕâ¸öÌù×ÓµÄÌáÎÊ·½Ê½http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html
1. ÄãµÄ create table xxx .. Óï¾ä
2. ÄãµÄ insert into xxx ... Óï¾ä
3. ½á¹ûÊÇʲôÑù£¬£¨²¢¸øÒÔ¼òµ¥µÄËã·¨ÃèÊö£©
4. ÄãÓõÄÊý¾Ý¿âÃû³ÆºÍ°æ±¾(¾³£ÓÐÈËÔÚMS SQL server°æÎÊ MySQL)
ÕâÑùÏë°ïÄãµÄÈË¿ÉÒÔÖ±½Ó´î½¨ºÍÄãÏàͬµÄ»·¾³£¬²¢ÔÚ¸ø³ö·½°¸Ç°½øÐвâÊÔ£¬±ÜÃâÎÄ×ÖÃèÊöÀí½âÉϵÄÎó²î¡£
MySQL
create table test1
(fid,title)
insert into test1 select '1','ÕÅÈý'
insert into test1 select '1','ÍõÎå'
insert into test1 select '1','ÍõËÄ'
insert into test1 select '2','ÐÅÏ¢XÍõËÄ·¢²¼'
insert into test1 select '3','ÐÅÏ¢XÍõÎå·¢²¼'
insert into test1 select '4','ÐÅÏ¢XXÍõÎå'
insert into test1 select '3','ÐÅÏ¢XXÍõËÄ·¢²¼'
insert into test1 select '3','ÐÅÏ¢XXXÍõËÄ·¢²¼'
insert into test1 select '1','XXXÕÅÈý·¢²¼'
/*
ÒªµÃµ½ÕâÑùµÄÅÅÐб¨±í£º
n
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......