select statment only return one coloumn
Posted by:
SAGI 1
Date: June 25, 2015 11:40AM
Hey all
I am not femiliar with MySQL workbence previously worked with Oracle.
I have a problem when I try to return to rows from a table.
for example
table customers with rows name,id,phone
1. select * from customers - worked ok
2. select name,id from customer where name = NINJA
the result is only name, not displayed the coloumn ID
Moreover ID is the headline instead of name.
result:
ID
Ninja
how can I aolvw this issue?
regards
Subject
Views
Written By
Posted
select statment only return one coloumn
1200
June 25, 2015 11:40AM
455
June 26, 2015 12:47AM
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.