| List: | MySQL on Win32 | « Previous MessageNext Message » | |
| From: | Paul DuBois | Date: | February 5 2000 12:21am |
| Subject: | Re: LIMIT RND * 10 | ||
| View as plain text | |||
At 9:09 PM -0300 2000-02-04, Ernesto wrote: >I can't do this: > >SELECT * FROM mytable LIMIT (RND * 10),1 > >why? Isn't that a legal sentence? No. LIMIT requires constants, not expressions. -- Paul DuBois, paul@stripped
| Thread | ||
|---|---|---|
| • LIMIT RND * 10 | Ernesto | 5 Feb |
| • Re: LIMIT RND * 10 | Paul DuBois | 5 Feb |
| • Re: LIMIT RND * 10 | sinisa@mysql.com | 5 Feb |