MySQL创建触发器的例子例：//创建日志sql = "CREATE TABLE `logs` (`Id` int(11) NOT NULL AUTO_INCREMENT,`log` varchar(255) DEFAULT NULL COMMENT \"日志说明\",PRIMARY KEY(`Id`)) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = \"日志\";";//创建触发器sql = "CREATE TRIGGER hello_log AFTER INSERT ON `hello` FOR EACH ROW \n \ BEGIN\n \ DECLARE s1 VARCHAR(40)character set utf8;\n \ DECLARE s2 VARCHAR(20)character set utf8;\n \ SET s2 = \" is created\";\n \ SET s1 = CONCAT(NEW.`编号`, s2);\n \ INSERT INTO logs(log) values(s1);\n \ END;"; //如果是奇数中文，建议加一个中文的标点符号，不然可能报错，所尽量使用偶数个中文//NEW新的数据 CONCAT内置函数 把两个字符串合并