On using SQL Script generated by 'generate DDL Script' Function for MySQL 5.0 the following error appears:
'Error Code : 1064
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 5 (0 ms taken)'
The syntax of the generated create trigger script is the following:
1 CREATE DEFINER = <user> TRIGGER <trigger_name> AFTER INSERT
2 ON <tbl_name>
3 FOR EACH ROW
4 BEGIN
5 <trigger_stmt>
6 END
7 ;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center