Re: delete from table limit @var; is not working

At 22:51 +0400 4/28/04, qwerq qerq wrote:
>The following command:
>delete from table limit @var;
>says syntax error... why?

The manual says this is not allowed.

http://dev.mysql.com/doc/mysql/en/Variables.html says:

User variables may be used where expressions are allowed. This does not
currently include contexts that explicitly require a number, such as in the
LIMIT clause of a SELECT statement, or the IGNORE number LINES clause of a
LOAD DATA statement.


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]