create view in mysql 4
Posted: Sun Feb 26, 2006 5:39 am
i wish to make a simple interogation in mysql 4.1.14-standard-log like this
create view v as select * from table1
and i get the folowing error:
#1064 - 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 v AS SELECT * from table1' at line 1
create view v as select * from table1
and i get the folowing error:
#1064 - 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 v AS SELECT * from table1' at line 1