Views (including updatable views) are being implemented in the 5.0 version
of MySQL Server. They are already available in binary releases from 5.0.1
sirisha gnvg <siri_gnvg@stripped> wrote:
> [-- text/plain, encoding 8bit, charset: iso-8859-1, 18 lines --]
> we are working on mysql 4.1.8 and windows XP platform.
> This version supports views.We created a view like this
> mysql>use sample
> mysql>create view v1 as select * from sam2;
> sam2 is a table
> We got an error
> errror 1024(42000):you have an error in your sql syntax;
> we checked the manual but the syntax is as written above.we also saw error 1024 in
> error notepad but we could not get any further details.
> please explain the fault in above statement
> Yahoo! India Matrimony: Find your life partneronline.
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET