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.

Reply via email to