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

mysql updateÓï¾äµÄÎÊÌâ

ÎÒÏëÒª¸üÐÂij¸ö±íÅÅÐòºó¿¿Ç°µÄÊý¾Ý£¬ÓÚÊÇдÁËÒ»¸öÓï·¨£º
update dcproduct set pOrder=pOrder+2 order by pOrder desc,id desc limit 6£»Õâ¸öÊÇ¿ÉÒÔÔËÐе쬽á¹ûÊǸüÐÂÁËǰÁùÌõ¼Ç¼¡£
ºóÀ´·¢ÏÖ©Á˸öÌõ¼þÒªÁ¬±í²éѯÓÚÊÇд³É£º
update dcproduct a join dcproductsort b on a.pSortid=b.id set pOrder=pOrder+2 where parentid=1 order by a.pOrder desc,id desc limit 6;
½á¹û¾Í±¨´íÁË£¬

ÓÐûÓÐÈËÖªµÀÔõôд°¡£¿
±¨´íÐÅÏ¢ÊÇʲô£¿ ûÓбØÒªÈôó¼Ò²Â°É¡£

#1221 - Incorrect usage of UPDATE and ORDER BY

UPDATEÖÐÈç¹ûÊÇÁ½¸ö±í£¬Ôò²»ÄÜʹÓà order / limit

²»ºÃÒâ˼,ÎÒÏëÒª½â¾ö°ì·¨£¬²»ÊÇ´íÎóÔ­Òò....

²»ºÃÒâ˼,ÎÒÏëÒª½â¾ö°ì·¨£¬²»ÊÇ´íÎóÔ­Òò....

try:
update dcproductsort b join
(select * from dcproduct
order by pOrder desc,id desc limit 6) a
  on a.pSortid=b.id set pOrder=pOrder+2 where parentid=1

½¨Ò鏸³öÄãµÄ²âÊÔÊý¾Ý£¬ÕâÑù±È½ÏÈÝÒ×Á˽âÄãµÄÐèÒªÊÇʲô¡£

½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£

6Â¥µÄ´ó´ó£¬±¨´í
#1288 - The target table a of the UPDATE is not updatable


ÎÒµÄÊý¾ÝºÜ¼òµ¥£¬product±íÊDzúÆ·£¬productsortÊÇ·ÖÀ࣬pOrderÊDzúÆ·µÄÅÅÐò×ֶΣ¬Ç°Ì¨ÅÅÐò°´ÕÕ ÅÅÐò×ֶκÍid×Ö¶ÎÅÅ£¬
ĿǰҪ×öµÄ¾ÍÊǰÑǰ̨ÏÔʾÔÚ×îÇ°ÃæµÄ¼¸ÌõÊý¾ÝµÄpOrderÔö¼Ó2¡£

ÏÈлл´ó¼Ò°ïÖúÀ­£¬Èç¹û²»ÐÐÎÒÖ»ÄÜͨ¹ýÆäËû³ÌÐòʵÏÖÁË¡£

ÔÚMYSQL¡¡5¡£.1¡£32ϲâÊÔ£¬SQLÓï¾äûÓÐÎÊÌâ
UPDATE lsb3 b JOIN
(SELECT * from lsb2


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

MYSQL Êý¾Ý½ØÈ¡

MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);

¶¥£¬Ñ§Ï°

SQL code: ......

MysqlÁ¬½Óoracle

ÐèÒªÔÚMySQLÀïÃæÐ´¸ö´¢´æ¹ý³Ì,
·ÃÎÊoracleµÄÊý¾Ý.
Ŀǰ²»ÄÜ

oracle¿ÉÒԾͿÉÒÔÁ¬½Ómysql£¬Í¨¹ýodbc+dblinkÀ´Á¬½Ó

ûÓа취¡£Ä¿Ç°µÄMYSQLµÄ°æ±¾ÖÐÉв»Ö§³ÖÁ¬½Óµ½ÆäËüÊý¾Ý¿â£¬

ÕæÍ¦ÓÐÏë·¨µÄ ĿǰÎÒû×ö¹ý ......

mysql´¢´æ¹ý³ÌµÄÎÊÌâ

ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ