ÇëÎÊmysql root rootÊÇÒ»ÌõʲôÃüÁî
²»Ð¡ÐÄÔÚCMDÀïÇÃÁË mysql root root »Ø³µÖ®ºó³öÏÖÒ»´ó¶Ñ¿´²»¶®µÄEÎÄ¡£ÇëÄÇλ°ïæ½âÊÍÕâÌõÃüÁîÊÇʲôÒâ˼£¿
ÁíÍâ±¾È˸Õ×ÔѧSQL¡£ÓÐʲôºÃµÄÊé½éÉÜһϣ¡£¡£¡
ÁíÍâ±¾È˸Õ×ÔѧSQL¡£ÓÐʲôºÃµÄÊé½éÉÜһϣ¡£¡£¡
¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·
MYSQL ÈëÃÅ
http://dev.mysql.com/doc/refman/5.1/zh/tutorial.html
¹Ù·½²Î¿¼Îĵµ°¡
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
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. ......
ÓÐÒ»¸ö±í mytable ÓÐÏÂÃæ¼¸¸ö×Ö¶Î
id class(ѧÉú°à¼¶) studentSex(ѧÉúÐÔ±ð,1ÄÐ2Å®) studentName(ѧÉúÐÔÃû)
¼ÙÉèÏÖÓÐÊ®¼¸¸ö°à¼¶,
ÎÒÏë»ñµÃ°à¼¶ÖÐÄÐѧÉú×î¶àµÄÈýÌõÏàÓ¦ ......