maria-discuss team mailing list archive

[AskMonty KB <noreply@xxxxxxxxxxxx>]

Hello,

A new question has been asked in "SQL Structure and Commands" by girish2477. Please answer it at http://mariadb.com/kb/en/unable-to-create-after-insert-trigger-on-mariadb/ as the person asking the question may not be subscribed to the mailing list.

--------------------------------
Hi,

I followed trigger instructions from documentation. When i run the script from command line, cursor does not come back. i have to kill the execution

Server version: 5.5.46-MariaDB MariaDB Server

Tried various formats

CREATE TRIGGER company_insert 
AFTER INSERT ON companyMain
FOR EACH ROW 
INSERT INTO companytest (ID, Value) VALUES (20, CONCAT(NEW.`Code`,' - ',NEW.`Name`));
------------
DELIMITER //
DROP TRIGGER IF EXISTS company_insert ;
CREATE TRIGGER company_insert 
AFTER INSERT
   ON companyMainFOR EACH ROW   
BEGIN
	DECLARE vFormatID int;
	SET vFormatID=20;
   INSERT INTO companytest (ID,Value) VALUES ( vFormatID,NEW.`Name`);   
END; //
DELIMITER;

Tried running from command directly or pass as .sql file. both ways its stuck no response back on command. Have to kill.
^CCtrl-C -- query killed. Continuing normally.
ERROR 1317 (70100) at line 3: Query execution was interrupted

Your help will be appreciated.

--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-create-after-insert-trigger-on-mariadb/