Problem about MYSQL

I am using MySQL.

After I manually logged in, I mean, using "mysql -u username -p passward",

I tried to CREATE VIEW by using the following command:

mysql> CREATE VIEW csclass AS SELECT * FROM CSGRADE10;

Here, CSGRADE10 is the table already been created.

The error message is:

ERROR 1064: You have an error in your SQL syntax near 'VIEW csclass AS SELECT *

FROM CSGRADE10' at line 1

What's the problem?

Thanks.

Jack

[495 byte] By [jw2001] at [2007-9-26 2:04:12]