DELIMITER :
DELIMITER //
CREATE TRIGGER t_bu BEFORE UPDATE ON t
FOR EACH ROW
BEGIN
DECLARE CONTINUE HANDLER FOR 1264 SET new.column1... l>
delimiter //
CREATE TRIGGER survey_check_empty BEFORE INSERT ON surv_surveys
FOR EACH ROW
BEGIN
IF LENGTH(NEW.survey_name) <1 THEN
RETURN FALSE;
END IF
Purging Binary Log Files While Replicating]]
To be sure replication is not broken while deleting log... tly reading.
* Find the earliest log file still being read by a replica. No log files before this one will be needed.
* If you wish, make a backup of the log files to be deleted
* Purge
