Search
Main Menu
Login
Username:

Password:

Remember me



Lost Password?

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

Members: 0
Guests: 16

more...

Error: Subquery Returns More than 1 Row in MySQL


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

What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDATE statement, it must return exactly one row for each row in the update table that matches the WHERE clause. If it returns multiple rows, MySQL server will give you an error message. To test this out, ... - Rank: 263; Updated: 2018-01-08 -> Source

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

Copyright (c) FYIcenter.com