建一个视图,写好sql语句执行报错
[Err] 1060 - Nom du champ 'Schoolname' déjà utilisé
sql语句如下:
create view v_user as
SELECT u.*,s.Schoolname FROM usertab u,schoolinfo s
where u.SchoolID=s.ID
解决方案:select后面的字段名s.Schoolname加上单引号就OK了
create view v_user as
SELECT u.*,'s.Schoolname' FROM usertab u,schoolinfo s
where u.SchoolID=s.ID