mysql Ææ¹ÖµÄ´íÎó
½ñÌì¸ã PHP ¿ª·¢µÄʱºò£¬¸ã³öÁËÕâ¸ö´íÎó£º
ÎÒÖ´ÐеÄÓï¾äÊÇ£º
INSERT INTO `tb_Replies`(`W_ID`,`R_Name`,`R_Contact`,`R_Content`) VALUES (98,'test','test','test');
½á¹û¾¹È»·µ»Ø´íÎó£º
1146:Table 'mysite.writings' doesn't exist
´ó¼Ò¿´Çå³þÁË£¬ÎÒ²åÈëµÄÊÇ tb_Replies ±í£¬½á¹û¾¹È»·µ»Ø writings ±í²»´æÔÚ£¨ÊÂʵÉÏÎÒÊý¾Ý¿âÀï¸ù±¾Ã» writings Õâ±í£©¡£
¶øÇÒ£¬ËäÈ»·µ»ØÁË´íÎó£¬Êý¾ÝÈ´ÊDzåÈë³É¹¦¡£
´ó¼ÒÓÐûÓÐÓöµ½¹ýÀàËÆµÄÎÊÌâ £¿¸ÃÈçºÎ½â¾ö£¿
ÊÔÁËһϣ¬Ã²ËÆÃ»Ê²Ã´Ìرð¡£
ÄÜ´ÓÖп´³öµÄÊÇ£¿
²»ÖªµÀ£¬Äõ½ÄãµÄcreate table Óï¾ä£¬ÕâÑù²ÅÄÜ×öʵÑé¡£
ÁíÍâÓÐûÓÐʲô´¥·¢Æ÷ÔÚÕâ¸ö±íÉÏ¡£
ûÓд¥·¢Æ÷£¬¶øÇÒÕâ¸öÊý¾Ý¿âÖÐÖ»ÓÐÕâ¸ö±íÓòåÈëÓï¾äÊdzö´íµÄ¡£
| tb_Replies | CREATE TABLE `tb_Replies` (
`R_ID` int(10) unsigned NOT NULL auto_increment,
`R_Name` varchar(15) NOT NULL,
`R_Contact` varchar(30) NOT NULL,
`R_Content` varchar(400) NOT NULL,
`R_Time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`W_ID` int(10) unsigned NOT NULL,
`F_R_ID` int(10) unsigned NOT NULL default '0',
PRIMARY KEY USING BTREE (`R_ID`),
KEY `W_ID` USING BTREE (`W_ID`),
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
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. ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿
1 nike 100 ϵͳʱ¼ä
2 nike 300 &n ......