MySQL Trigger programmatically in C#

Question

I have problem with creating a simple MySQL trigger in C#. I'm using StringBuilder to build the following command string:

DELIMITER $$

DROP TRIGGER /*!50032 IF EXISTS */ dbname.table$$

CREATE TRIGGER dbname.inserttrigger AFTER INSERT ON dbname.table

FOR EACH ROW BEGIN

...

END;

$$

DELIMITER ;

when I try cmd.executeNonQuery() an Exception occurs (Error in SQL syntax) which is despite the new lines referring to LINE 1. - The Stringbuilder will put in "\r\n" for every AppendLine().

If I copy and paste the command to the MySQL console it runs fine.

Abel · Accepted Answer · 2009-11-02 15:31:37Z

1

This seems to have been a bug in MySQL with the DELIMITER statement, not sure it's the same you're hitting. Was fixed in a recent version of MySQL. If you're not using the latest version, try to update MySQL and try again.

answered Nov 2, 2009 at 15:31

Abel

57.5k25 gold badges159 silver badges260 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

G Berdal Over a year ago

Thanks Abel. I'm using 5.0.77. I'll upgrade to 5.1.

Collectives™ on Stack Overflow

MySQL Trigger programmatically in C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related