阅读全文>>

执行，就会报 The definition of table 'table1' prevents operation UPDATE on table 'table2'

update table2 set item = replace(item,'A27-','A28-')
where id in(
select id from table1 where
 item like ...

阅读全文>>