sql query

[ivan drago]

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.

br

http://www.allgamblingreviews.com