Skip navigation links

MySQL Forums :: Newbie :: trying to get output on 1 row


Advanced Search

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


Subject Written By Posted
trying to get output on 1 row will landymore 04/18/2012 08:35PM
Re: trying to get output on 1 row laptop alias 04/19/2012 01:15AM
Re: trying to get output on 1 row Rick James 04/20/2012 11:41PM


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.