CREATE TRIGGER `refbrouser` BEFORE INSERT ON `guestbook` FOR EACH ROW BEGIN SET NEW.user_browser = 'dddddddd'; END
and get this errors Why?: 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 '' at line 3 Line 1, column 1
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 'END' at line 1 Line 4, column 1
Execution finished after 0 s, 2 error(s) occurred.
View All Comments