Search
Main Menu
Login
Username:

Password:

Remember me



Lost Password?

Register now!
Who's Online
15 user(s) are online (11 user(s) are browsing Jobs & News)

Members: 0
Guests: 15

more...

UPDATE with Subquery Returning No Rows in MySQL


Author: FYIcenter.com | FYI Center for Database Administrator
Date: Jan 07, 2018
Views: 0

What Happens If the UPDATE Subquery Returns No Rows in MySQL? If you use a subquery to assign new values in the SET clause in an UPDATE statement, and the subquery returns no rows for an outer row, MySQL will provide a NULL value to the SET clause. The tutorial exercise below shows you a good exampl... - Rank: 257; Updated: 2018-01-08 -> Source

URL: http://www.fyicenter.com/modules/planet/view.article.php?420411
Trackback: http://www.fyicenter.com/modules/planet/trackback.php?420411

Copyright (c) FYIcenter.com