jaydeep posted

You can't specify target table 'TABLE_NAME' for update in FROM clause in MySQL

i am trying to rub sub query for update query in MySQL


update   TABLE_NAME set ROW=1 where id in (select id from TABLE_NAME where ROW2='')

and got error


 You can't specify target table 'TABLE_NAME' for update in FROM clause

you can use sub query for select query for same target.


select   * from TABLE_NAME  where id in (select id from TABLE_NAME where ROW2='')

but no sub query work for update for same target table

Post Answer

OMG! You need to Login / Register to Post Answer

[code] Bold LE LP LD LW LDR WAR INF DAN SUC FYI h2 h3 italic