"create view .." doesn't work for mysql

[gundamz]

Hi all,

any ideas why this mysql command doesn't work on phpmyadmin on cpanel server.

CREATE VIEW TEST AS SELECT * FROM COURSE

it give this 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 TEST AS SELECT * FROM COURSE\' at line 1

[gdelfino]

Are you using MySQL 5?