MySQL Forums
Forum List  »  MySQL Workbench

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

Options: ReplyQuote


Subject
Views
Written By
Posted
select statment only return one coloumn
1200
June 25, 2015 11:40AM


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.