MySQL Forums
Forum List  »  Views

problem with view
Posted by: nikunj kansara
Date: March 24, 2011 10:06PM

Hi all,

I am using view in mysql and when i create view i found Error msg Like

"SELECT contains variables and parameters"

I am using mysql 5.0.77

My view statement like

CREATE VIEW test1 AS select dept.AcademicName, ds.SubjectID, dept.DeptID, @val = concat(@val,dept.AcademicName,",") as depName from tbldegreesubjectmst AS ds LEFT JOIN tbldepartmentmst AS dept ON dept.DeptID = ds.DeptID where ds.SubjectID = 1

Please replay me.



Edited 1 time(s). Last edit at 03/24/2011 11:18PM by nikunj kansara.

Options: ReplyQuote


Subject
Views
Written By
Posted
problem with view
3112
March 24, 2011 10:06PM
1626
March 25, 2011 01:52AM
1345
April 01, 2011 12:31AM


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.