mysql - 错误 1093 (HY000) : You can't specify target table for update in FROM clause

Question

我尝试了以下查询:

mysql> INSERT INTO tm_visitor (VDT,VID, NAME, CONTACT) values(REPLACE(LE
FT(NOW(), 10), '-', ''),(SELECT LPAD(COALESCE(MAX(VID) + 1, 000001), 6, '0') FRO
M tm_visitor),'yatin','9876543120');

但我收到以下错误。

ERROR 1093 (HY000): You can't specify target table 'tm_visitor' for update in FROM clause`

出了什么问题，我该如何解决？

Answer 1

INSERT INTO tm_visitor (VDT,VID, NAME, CONTACT) 
SELECT REPLACE(LEFT(NOW(), 10), '-', ''), 
   LPAD(COALESCE(MAX(VID) + 1, 000001), 6, '0'), 
   'yatin','9876543120' 
FROM tm_visitor