Create View

[Crundy]

I must be going mad! How come I can't create a view?

mysql> create view testview as select * from userdetails;
ERROR 1064 (42000): 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 testview as select * from userdetails' at line 1

C:\DOS:>
C:\DOS:>RUN
RUN DOS RUN!!

 

[Crundy]

Oh OK. Looks like Views are only supported in version 5 and up.

C:\DOS:>
C:\DOS:>RUN
RUN DOS RUN!!

 

[ericbrunson]

Sad, but true.