MySQL Forums
Forum List  »  Newbie

trying to get output on 1 row
Posted by: will landymore
Date: April 18, 2012 08:35PM

I have a web interface with a search field where I'm testing queries on the DB and I'm testing it with:

(SELECT user FROM mysql.user) and it's giving me the message "Subquery returns more than 1 row". However, if I change it to use something like:

(SELECT user FROM mysql.user LIMIT 1) it doesn't show anything.

How can I get the proper results, all users in the mysql.user and have them spit out on one row or give me anything at all?

Options: ReplyQuote

Written By
trying to get output on 1 row
April 18, 2012 08:35PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.