I meant the error is:
mysql> CREATE TRIGGER testref BEFORE INSERT ON bookmarks
-> FOR EACH ROW
-> BEGIN
-> IF NEW.title LIKE '%xxx%' THEN
-> SET NEW.id ='xxx';
ERROR 1064 (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 'SET NEW.id ='xxx'' at line 5
mysql> END IF;
ERROR 1064 (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 'END IF' at line 1
mysql> END;
ERROR 1064 (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 'END' at line 1
