insert into + select from 同一张表 的问题
insert into metergroup set SensorNo=3042, Parent=(select No from metergroup where GroupName='198_20181025_120442' limit 1)
会提示错误:#1093 - You can't specify target table 'metergroup' for update in FROM clause
就是同一张表用 insert 与 select from 会出错,请问正确的应该怎么写