Error code 1064, SQL state 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BEGIN
INSERT INTO mst_gate
(gate_id
,gate_name
,status
)
VALUES' at line 2
DELIMITER @@
CREATE TRIGGER vms.ins_gate
BEGIN
INSERT INTO `mst_gate` (`gate_id`,`gate_name`,`status`)
VALUES (new.gate_id, new.gate_name, new.status);
END @@
DELIMITER ;
Wrong trigger syntax,try
DELIMITER @@
CREATE TRIGGER vms.ins_gate BEFORE INSERT ON sometable
FOR EACH ROW
BEGIN
INSERT INTO `mst_gate` (`gate_id`,`gate_name`,`status`)
VALUES (new.gate_id, new.gate_name, new.status);
END @@
DELIMITER ;