更新该句
updateda_questionsetanswer_time=now()
whereidin(
selectidfromda_questionwhereanswer_timeisnullandidin(selectdistinctparent_idfromda_question)
)
在MySQL命令列工具中傳回:
ERROR1093(HY000):Youcan'tspecifytargettable'forum_members'forupdateinFROMclause
改成下列命令處理就可以解决无法更新的问题
updateda_questionainnerjoin(selectidfromda_questionwhereanswer_timeisnullandidin(selectdistinctparent_idfromda_question))bona.id=b.idsetanswer_time=now();
来自:http://os.chinaunix.net/a2008/0516/980/000000980235.shtml
本文转自 wbb827 51CTO博客,原文链接:http://blog.51cto.com/wbb827/1308787