Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Franc Walter
December 11, 2006, 4:18 pm
rate this thread
i didn't find it in the help, i think it is not possible, but i try to
Is the MySQL command "LIMIT" possible with a subquery in MySQL 4.0.27?
e.g.: SELECT * FROM tab1 LIMIT (SELECT COUNT(*) from tab2)
this doesn't work.
MySQL 5.1 writes:
User variables may be used in contexts where expressions are allowed.
This does not currently include contexts that explicitly require a
literal value, such as in the LIMIT clause of a SELECT statement, or
the IGNORE N LINES clause of a LOAD DATA statement...
Is there a workaround?
- » Deadlock found when trying to get lock (MySQL 5.0 with innodb)
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum