UPDATE user_word SET `TF-IDF` =
(
SELECT user_word.`TF` * words.`IDF` FROM user_word uw, words w
WHERE uw.source = src AND w.source = src AND uw.word = w.word
);执行时提示:You can't specify target table 'user_word' for update in FROM clause
说不能更新和查询同一个表吗?求大神指教。
(
SELECT user_word.`TF` * words.`IDF` FROM user_word uw, words w
WHERE uw.source = src AND w.source = src AND uw.word = w.word
);执行时提示:You can't specify target table 'user_word' for update in FROM clause
说不能更新和查询同一个表吗?求大神指教。
SELECT user_word.`TF` * words.`IDF` as k
FROM user_word uw, words w
WHERE uw.source = src AND w.source = src AND uw.word = w.word
) b
set a.`TF-IDF` = b.k
inner join words w
on
uw.source = src AND w.source = src AND uw.word = w.word
SET `TF-IDF` = uw.`TF` * ws.`IDF`