· 8 years ago · Jul 01, 2018, 10:12 AM
1CREATE DEFINER=`root`@`localhost` FUNCTION `testFun`(oldStr VARCHAR(256), newStr VARCHAR(256)) RETURNS boolean
2BEGIN
3
4 CREATE TABLE IF NOT EXISTS association.Association(email VARCHAR(30) NOT NULL, maskedEmail VARCHAR(30) NOT NULL);
5
6 INSERT INTO association.Association (email, maskedEmail) VALUES (oldStr, newStr );
7
8 RETURN TRUE;
9
10END
11
12ERROR 1422: Explicit or implicit commit is not allowed in stored function or trigger.