Tag Info

New answers tagged

0

This would work ; UPDATE users SET users.email = (SELECT mytable.email FROM mytable WHERE mytable.id = users.id) WHERE EXISTS (SELECT mytable.email FROM mytable WHERE mytable.id = users.id) AND users.email IS NULL;


0

So to answer your question. "So will the command retrieve it normally or give an error?" Yes it will work and won't return an error. @update You forgot your ; after the query.



Top 50 recent answers are included