mysql触发器

DELIMITER $   #定义$为结束符
TRUNCATE gt_hotel$ #清空table o
CREATE TRIGGER tr_aft_insert_hotel
AFTER INSERT ON gt_hotel
FOR EACH ROW
BEGIN
INSERT INTO gt_template(source_id,source_type) VALUES (new.id,1);
END$