Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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åÈë³É¹¦¡£

´ó¼ÒÓÐûÓÐÓöµ½¹ýÀàËÆµÄÎÊÌâ £¿¸ÃÈçºÎ½â¾ö£¿

ÒýÓÃ
show create table  `tb_Replies`

¿´Ò»ÏÂÊÇʲô£¿


ÊÔÁËһϣ¬Ã²ËÆÃ»Ê²Ã´Ìرð¡£

ÄÜ´ÓÖп´³öµÄÊÇ£¿

²»ÖªµÀ£¬Äõ½ÄãµÄ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`),


Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

Mysql Êý¾Ý¿âɾ³ý²»ÁËÔõô°ì

ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿


ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©

......

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

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. ......

mysql ¼òµ¥ÎÊÌâ

¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿

1  nike  100        ϵͳʱ¼ä
2  nike  300  &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ