MySQL Forums
Forum List  »  Quality Assurance

sql query
Posted by: ivan drago
Date: November 07, 2011 06:41PM

Hi there,

I tried to create a view. The following are the statements given.

create table Emp (E_code varchar(10), E_name varchar(30),E_age int)

I created a table with the above structure. It is created. After that I tried to create a view from this table. I used the following statement.

create view Emp_View as (select * from Emp)

At that time system is showing the following error

Error Code : 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 Emp_View as (select * from Emp)' at line 1
(0 ms taken)

One more thing is that Objects->View->Create View option is seen disabled at all time.

Please help me.


Options: ReplyQuote

Written By
sql query
November 07, 2011 06:41PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.