Making a view

[John Penney]

OK,

Maybe I didn't do this right the last time - I don't see my post here.

I am trying to build a very simple view, and I'm getting an error message.

Anyone know what's wrong with the following syntax?

create view junk as select * from mytable;

The error I get is ERROR 1064 (42000).

Thanks.

JP