Re: LOAD DATA INFILE ERROR 1172 (42000)

[eric tse]

mysql> show triggers
-> ;
+-------------+--------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------+------------------+----------------------+----------------------+--------------------+
| Trigger | Event | Table | Statement


| Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation |
+-------------+--------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------+------------------+----------------------+----------------------+--------------------+
| lbip_insert | INSERT | ServerIPs | BEGIN

DECLARE tmp_lbip VARCHAR(15);
DECLARE tmp_balance VARCHAR(25);
DECLARE tmp_n1keepalive VARCHAR(30);
DECLARE tmp_n1ip VARCHAR(15);
DECLARE tmp_n2ip VARCHAR(15);
DECLARE tmp_n2keepalive VARCHAR(30);

CASE
WHEN (NEW.server LIKE "%mallet%") OR (NEW.server LIKE "%cleek%") THEN
BEGIN
SET tmp_lbip = (SELECT DISTINCT lbip FROM CSSInfo WHERE ip=NEW.regip);
END;
ELSE
BEGIN
SELECT DISTINCT lbip,balance,n1ip,n1keepalive,n2ip,n2keepalive INTO tmp_lbip,tmp_balance,tmp_n1ip,tmp_n1keepalive,tmp_n2ip,tmp_n2keepalive
FROM LBInfo WHERE n1ip=NEW.regip OR n2ip=NEW.regip;
IF tmp_n1ip=NEW.regip THEN
SET NEW.keepalive = tmp_n1keepalive;
ELSE
SET NEW.keepalive = tmp_n2keepalive;
END IF;
SET NEW.balance = tmp_balance;
END;
END CASE;

SET NEW.lbip = tmp_lbip;

IF EXISTS(SELECT * FROM ListenIPs WHERE ip=NEW.regip) THEN
SET NEW.used = 'Y';
ELSE
SET NEW.used = 'N';
END IF;

END | BEFORE | NULL | | apache@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci |
+-------------+--------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------+------------------+----------------------+----------------------+--------------------+
1 row in set (0.03 sec)