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

Written By
problem with view
March 24, 2011 10:06PM
March 25, 2011 01:52AM
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.