mysql select column from view problem

Posted by haim evgi on Stack Overflow See other posts from Stack Overflow or by haim evgi
Published on 2010-06-10T06:33:39Z Indexed on 2010/06/10 6:52 UTC
Read the original article Hit count: 287

Filed under:
|
|

i create a view table like :

CREATE VIEW ViewManager AS
SELECT 
us.UserId AS 'Account Manager', .........

after that, when i run a query to select data from this view

like :

SELECT  'Account Manager' , .. from ViewManager

then the data i get in this column is the text 'Account Manager' and not the value of the this columns.

Is there a way to solve this ? Of course I can change the field name , but i want to know if there is another solution,

thanks.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about views