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/
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
