I'm trying to write a view for the first time. I cannot determine the error. This seems to match an example I found, but it won't work. What is missing?
this statement works:
SELECT * FROM rec1.cd_data
this statement does not work:
create view rec1.view_cd_data as SELECT * FROM rec1.cd_data
You have an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near
'view rec1.view_cd_data as SELECT * FROM rec1.cd_data' at line 1
