SELECT p . *, l.lv_Date
FROM `people` AS p LEFT JOIN `leave` AS l
ON p.pl_Personid = l.lv_Tutor
WHERE p.pl_Usertype = 2 AND IF(l.lv_Date != NULL, l.lv_Date Not in ('2012-5-27'), NULL)

LOAD DATA LOCAL INFILE 'file-path/file_name.csv' INTO TABLE table_name
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'

For more details
  http://dev.mysql.com/doc/refman/5.1/en/load-data.html

DROP TRIGGER IF EXISTS `updateInstancesResults`;
DELIMITER //
CREATE TRIGGER `updateInstancesResults` AFTER INSERT ON `form_results`
 FOR EACH ROW BEGIN
    DECLARE showPendingInstance INT(10);
    UPDATE instances SET response_status = 'taken' WHERE instance_id = NEW.instance_id;
    SET showPendingInstance     = (SELECT `value` FROM `attribute_xref` WHERE form_id = NEW.form_id AND `attribute_id` =2 LIMIT 1);
    IF (showPendingInstance = 0) THEN
           UPDATE instances SET response_status = 'skipped', status = 0 WHERE form_id = NEW.form_id
        AND response_status = 'pending'
        AND instance_id < NEW.instance_id;
    END IF;
  END
//
DELIMITER ;