Could someone give me an example of a select * with LIMIT used
by 6.5? --poet@linuxports.com-- ICQ: 33017215http://www.linuxports.com --Power to the Penguin--
> > Could someone give me an example of a select * with LIMIT
> > used by 6.5?
>
> SELECT * FROM foobar LIMIT 100
Or you could use ROWCOUNT...
set rowcount = 10
select * from table
Regards,
Mark.
--
Mark Jewiss
Knowledge Matters Limited
Dirk Lutzebaeck ha scritto:
> Besides, I have problems with SELECT LIMIT on unions in
> 6.5beta1. Anyone else?
>
> Dirk
LIMIT doesn't work with UNION, I think this is a known bug.
José