view like in sql2000

[orangelight]

Hi
I have just started to look at mysql. I had to download mysql 4.0 as i had problems running mysql 4.1+.

Basically I want to know is in SQL2000 i can create views, I was told I cannot create them in mysql and was wondering how I overcome this problem.

many thanks
hesh

 

[rzs0502]

Well, although you can play with permissions to create read-only access on tables/columns etc., it's not the same as having a few.

MySQL 5 (currently Beta) supports it.
If you're not using it in a prod environment, give it a try.
Another option would be to use the MaxDB / SAPDB from mysql.com



"If you always do what you've always done, you will always be where you've always been."