470,591 Members | 2,126 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

Create View Statements

How do I create a view?

I've read the help page on the mysql.org site but still cannot get

create view employee as select emp.name from emp, dept where
dept.id=emp.dept;

The select statement works fine on its own and I've changed the view name
a couple of times to avoid reserved words but still get Error 1064 : you
have an error in your sql syntax near... which leaves me none the wiser.

Clearly missing something obvious - please put me back on track.Thanks
Jul 20 '05 #1
3 2288
Balance wrote:
How do I create a view?

I've read the help page on the mysql.org site but still cannot get

create view employee as select emp.name from emp, dept where
dept.id=emp.dept;

The select statement works fine on its own and I've changed the view name
a couple of times to avoid reserved words but still get Error 1064 : you
have an error in your sql syntax near... which leaves me none the wiser.

Clearly missing something obvious - please put me back on track.Thanks


Isn't the lack of views being addressed in the next major version of mySQL ?

Perhaps thats why your statement doen't work.
Jul 20 '05 #2
Balance wrote:
How do I create a view?

I've read the help page on the mysql.org site but still cannot get

create view employee as select emp.name from emp, dept where
dept.id=emp.dept;

The select statement works fine on its own and I've changed the view name
a couple of times to avoid reserved words but still get Error 1064 : you
have an error in your sql syntax near... which leaves me none the wiser.

Clearly missing something obvious - please put me back on track.Thanks


Isn't the lack of views being addressed in the next major version of mySQL ?

Perhaps thats why your statement doen't work.
Jul 20 '05 #3
Balance wrote:
How do I create a view?

I've read the help page on the mysql.org site but still cannot get

create view employee as select emp.name from emp, dept where
dept.id=emp.dept;

The select statement works fine on its own and I've changed the view name
a couple of times to avoid reserved words but still get Error 1064 : you
have an error in your sql syntax near... which leaves me none the wiser.

Clearly missing something obvious - please put me back on track.Thanks


Isn't the lack of views being addressed in the next major version of mySQL ?

Perhaps thats why your statement doen't work.
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by kackson | last post: by
1 post views Thread by YONETANI Tomokazu | last post: by
1 post views Thread by Endif | last post: by
37 posts views Thread by Steven Bethard | last post: by
18 posts views Thread by Steven Bethard | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.