sirisha gnvg wrote:
>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.
>
>
Why don't you upgrade to 5.0? I use create view in 5.0 without any problem.
Sam
