List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:January 18 2005 8:12am
Subject:Re: create view not working on mysql 4.1.8
View as plain text  
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 <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
       <___/   www.mysql.com



Thread
create view not working on mysql 4.1.8sirisha gnvg18 Jan
  • Re: create view not working on mysql 4.1.8sam wun18 Jan
  • Re: create view not working on mysql 4.1.8Peter Brawley18 Jan
  • Re: create view not working on mysql 4.1.8Gleb Paharenko18 Jan