Hello.
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 and up. sirisha gnvg <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]