correction to the entered query it should be as 'select * from table limit 10 offset 20;'
thanks, vijay. --- In [email protected], "forbvijay" <forbvi...@...> wrote: > > hi, > > do any one know how to request a "live result set" in MySQl when query has > offset(eg: select * from table where limit 10 offset 20;). it is throughing > an error like 'invalid use of keyword'. > > Thanks, > Vijay. >
