$ mysql -h myhost -umyuser -p mysite_cms -e "show create trigger cal_tbl_event_delete\G"

Enter password:

*************************** 1. row ***************************

               Trigger: cal_tbl_event_delete

              sql_mode: IGNORE_SPACE

SQL Original Statement: CREATE DEFINER=`onecpd_cms`@`%` TRIGGER cal_tbl_event_delete

AFTER DELETE ON cal_tbl_event

FOR EACH ROW

        INSERT INTO delete_log(deleted_id, deleted_date, deleted_table)

    VALUES (Old.id, now(), 'cal_tbl_event');

  character_set_client: utf8

  collation_connection: utf8_general_ci

    Database Collation: utf8_general_ci

*************************** 1. row ***************************

               Trigger: cal_tbl_event_delete

              sql_mode: IGNORE_SPACE

SQL Original Statement: CREATE DEFINER=`root`@`localhost` trigger cal_tbl_event_delete

AFTER DELETE ON cal_tbl_event

FOR EACH ROW

  INSERT INTO delete_log(deleted_id, deleted_date, deleted_table)

VALUES (Old.id, now(), 'cal_tbl_event')

  character_set_client: utf8

  collation_connection: utf8_general_ci

    Database Collation: utf8_general_ci

               Created: 2016-10-28 20:54:05.31

#

# These groups are read by MariaDB server.

# Use it for options that only the server (but not clients) should see

#

# See the examples of server my.cnf files in /usr/share/mysql/

#

# this is read by the standalone daemon and embedded servers

[server]

# this is only for the mysqld standalone daemon

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

group=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=1

max_allowed_packet=16384000

group_concat_max_len=4294967295

innodb_buffer_pool_size=2560M

innodb_file_format = Barracuda

innodb_file_per_table = 1

query_cache_size=64M

query_cache_type=1

tmp_table_size = 16M

max_heap_table_size = 16M

max_connections = 1000

open_files_limit = 4096

table_cache = 4096

# this is only for embedded server

[embedded]

# This group is only read by MariaDB-5.5 servers.

# If you use the same .cnf file for MariaDB of different versions,

# use this group for options that older servers don't understand

[mysqld-5.5]

# These two groups are only read by MariaDB servers, not by MySQL.

# If you use the same .cnf file for MySQL and MariaDB,

# you can put MariaDB-only options here

[mariadb]

[mariadb-5.5]

DROP TABLE IF EXISTS delete_log;

CREATE TABLE delete_log (

  id INT NOT NULL AUTO_INCREMENT,

  deleted_id VARCHAR(35) NULL,

  deleted_date DATETIME NULL,

  deleted_table VARCHAR(100) NULL,

  deleted_type VARCHAR(100) NULL, 

  PRIMARY KEY (`id`));

DROP TRIGGER IF EXISTS cal_tbl_event_delete;

CREATE TRIGGER cal_tbl_event_delete

AFTER DELETE ON cal_tbl_event

FOR EACH ROW

	INSERT INTO delete_log(deleted_id, deleted_date, deleted_table)

    VALUES (Old.id, now(), 'cal_tbl_event');

DROP TRIGGER IF EXISTS cal_tbl_meeting_delete;

CREATE TRIGGER cal_tbl_meeting_delete

AFTER DELETE ON cal_tbl_meeting

FOR EACH ROW

	INSERT INTO delete_log(deleted_id, deleted_date, deleted_table)

    VALUES (Old.id, now(), 'cal_tbl_meeting');

DROP TRIGGER IF EXISTS cal_tbl_learning_plan_delete;

CREATE TRIGGER cal_tbl_learning_plan_delete

AFTER DELETE ON cal_tbl_learning_plan

FOR EACH ROW

	INSERT INTO delete_log(deleted_id, deleted_date, deleted_table)

    VALUES (Old.id, now(), 'cal_tbl_learning_plan');

DROP TRIGGER IF EXISTS tcontent_delete;

/* since this is executed via coldfusion we don't need the delimier statement. if run with the delimiter statement, the trigger doesn't get created  */ 

/* DELIMITER $$ */

CREATE TRIGGER tcontent_delete

AFTER DELETE ON tcontent

FOR EACH ROW 

BEGIN 

	/*log the ID only if the active version no longer exists */ 

	IF NOT EXISTS (select contentid from tcontent where active = 1 and display = 1 and approved = 1 and contentID = Old.contentID) THEN

		IF Old.subType in ('News','Report') THEN

			INSERT INTO delete_log(deleted_id, deleted_date, deleted_table, deleted_type)

			VALUES (Old.ContentID, now(), 'tcontent', lcase(Old.subType));

		ELSEIF Old.subType='FAQ' THEN

			/* insert the faqID that the content is associated with */

			INSERT INTO delete_log(deleted_id, deleted_date, deleted_table, deleted_type)

			SELECT f.id, now(), 'tcontent', 'faqs'

			FROM faq_tbl_faqs f

			WHERE f.ContentID = Old.ContentID;

		END IF;

	END IF;

END;

/* DELIMITER ; */

/*

//delete trigger not needed for resources as they are not deleted but unpublished

DROP TRIGGER IF EXISTS rsc_tbl_resources_delete;

CREATE TRIGGER rsc_tbl_resources_delete

AFTER DELETE ON rsc_tbl_resources

FOR EACH ROW

	INSERT INTO delete_log(deleted_id, deleted_date, deleted_table)

    VALUES (Old.resource_id, now(), 'rsc_tbl_resources');

*/

CREATE TRIGGER trigger_tt AFTER DELETE ON tt FOR EACH ROW DO 1; /*comment */

DROP TABLE IF EXISTS tt;

CREATE TABLE tt (id int);

DROP TRIGGER IF EXISTS trigger_tt;

DELIMITER ;;

CREATE TRIGGER trigger_tt

AFTER DELETE ON tt

FOR EACH ROW

	DO 1; /*!50003 */;;

DELIMITER ;

       try (Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/testj?user=root&allowMultiQueries=true")) {

            Statement stmt = connection.createStatement();

            stmt.execute(

                    "DROP TABLE IF EXISTS tt;\n" +

                            "CREATE TABLE tt (id int);\n" +

                            "DROP TRIGGER IF EXISTS trigger_tt;\n" +

                            "CREATE TRIGGER trigger_tt\n" +

                            "        AFTER DELETE ON tt\n" +

                            "        FOR EACH ROW\n" +

                            "        DO 2;" +

                            "DO 1");

        }