ÇóÒ»ÌõÅÅÐò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
Ïà¹ØÎÊ´ð£º
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......