mysqlµÄÊý¾Ý¿â£¬Ò»¸öÍâ¼üµÄÎÊÌâ¡£
a±íÖÐÓУ¨a1£¬b1£¬c1,a2,a3£©b±íÖÐÓУ¨b1,b2,b3£©c±íÖÐÓУ¨c1,c2,c3£©ÔÚ¶ÁÈ¡a1±íµÄͬʱ£¬ÔõôµÃµ½b1µÄ¶ÔÓ¦µÄB2,B3£¬ ÎÒµÄÒ»¸ötable±íÖÐÓõÄbµÄÃû³Æ£¨b2£©ºÍcµÄÃû³Æ£¨c2£©ºÍ£¨a1£¬a2£¬a3£© ÏÖÔÚÎÒÒªÔõôдsqlÓï¾äµÃµ½£¬Íâ¼üb1µÄ¶ÔÓ¦µÄÊôÐÔ
µÈ´ý£¬ ÒýÓà ÎÒµÄÒ»¸ötable±íÖÐÓõÄbµÄÃû³Æ£¨b2£©ºÍcµÄÃû³Æ£¨c2£©ºÍ£¨a1£¬a2£¬a3£© ÏÖÔÚÎÒÒªÔõôдsqlÓï¾äµÃµ½£¬Íâ¼üb1µÄ¶ÔÓ¦µÄÊôÐÔ Ã»¿´¶®ÄãÏëʵÏÖʲô ½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£ ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ© µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù. http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html Â¥Ö÷ËµÊ²Ã´ÄØ ¸ù±¾Ã»ÌýÃ÷°×ÎÊÌâÒâ˼ Äã°Ñ²âÊÔÊý¾ÝºÍ½á¹û¶¼Ìù³öÀ´ ±íaµÄ2¸öÍâ¼ü£¬b£¬c£¬¶ÁÈ¡aµÄÒ»ÌõÊý¾Ý£¬Ò»ÌõÊý¾ÝÖÐÓÐÍâ¼übºÍc£¬b±íÖÐÎÒÒªµÃµ½b2£¬ ¾ÍÊÇдһÌõÓï¾ä£¬µÃµ½a±íÖеÄËùÓÐÊý¾ÝºÍb±íÖеÄb2£¬c±íÖеÄc2£¬ ½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from ( SELECT tg.tguildname,c.cid, ( cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5 ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
´ó¼ÒºÃ: ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ: #include <stdio.h> #include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h" ......
ÓÐÒ»¸ö±í mytable ÓÐÏÂÃæ¼¸¸ö×Ö¶Î id class(ѧÉú°à¼¶) studentSex(ѧÉúÐÔ±ð,1ÄÐ2Å®) studentName(ѧÉúÐÔÃû) ¼ÙÉèÏÖÓÐÊ®¼¸¸ö°à¼¶, ÎÒÏë»ñµÃ°à¼¶ÖÐÄÐѧÉú×î¶àµÄÈýÌõÏàÓ¦ ......