| Bug #9653 | Cant Create a view | ||
|---|---|---|---|
| Submitted: | 5 Apr 2005 15:41 | Modified: | 5 Apr 2005 15:56 |
| Reporter: | Munnawar Mohammad | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 4.0.24 | OS: | Windows (Windows 2000 Service pack 4) |
| Assigned to: | CPU Architecture: | Any | |
[5 Apr 2005 15:56]
MySQL Verification Team
View are only supported by server version 5.0.XX
Description: create table emp (email varchar(50)); //looks Good insert into emp values ("m@yahoo.com"); //looks Good create view empview as select * from emp // PROBLEM ! THE FOLLOWING IS THE ERROR I GET 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 empview as select * from emp' at line 1 How to repeat: Follow the above steps