Re: LOAD DATA IF?

[Paul DuBois]

At 1:16 +0100 11/3/05, John thegimper wrote:

Is it possible to specify and IF statement or IGNORE statement when useing LOAD

DATA?
Example

SET price = IF PRICE(< 20) THEN IGNORE
SET price = IGNORE IF <20

What is the semantics of IGNORE?  What do you expect to happen?

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]