Table name specified twice both as a target for update and separate source for data

Question

Update table 
Set class = 0 
Where TOTAL_HOURS = (SELECT min (TOTAL_HOURS) from tutions);

Produced Error:

Table name specified twice both as a target for update and separate source for data.

How can I fix this?

is that the real query ? in your query you use table as tablename and table is a keyword. so you must quote it in backticks — Bernd Buffen, Apr 02 '17 at 18:04

score 12 · Answer 1 · answered Apr 02 '17 at 18:05

12

I am guessing you are trying to update tutions with tutions.

Make a nested subquery so that MySQL materializes it and is no longer the same table.

Try this:

Update tutions
Set class = 0 
Where TOTAL_HOURS = (select * from (SELECT min (TOTAL_HOURS) from tutions) t);

answered Apr 02 '17 at 18:05

Gurwinder Singh

I am sorry the Actual table is this, I was just trying to generalise for not getting others confused but I forgot to update the second one. – Rudra Upadhyay Apr 03 '17 at 11:45
Update table Set class = 0 Where TOTAL_HOURS = (SELECT min (TOTAL_HOURS) – Rudra Upadhyay Apr 03 '17 at 11:45
1

@Rudra - please EDIT your question and provide the real query, what you want to do with it. Also, sample data and expected results can be more helpful – Gurwinder Singh Apr 03 '17 at 15:23

1 Answers1