trying to get output on 1 row
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?
Subject
Written By
Posted
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.