Trigger error in mysql

Question

I want to insert informations from carti into domeniu but i get an error message.

CREATE TRIGGER trigger_UpdateItemDetails ON carti
FOR INSERT AS
BEGIN

INSERT INTO 
domeniu
(
    cod_d,
    materia,
    result
)
SELECT 
    id
    domeniu
    nr_exemplare
FROM 
   carti
END

The error message: #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 'ON result FOR INSERT AS BEGIN INSERT INTO domeniu ( ' at line 1

Post the error message as well.

Rahul
– Rahul

2016-01-09 17:53:28 +00:00
Commented Jan 9, 2016 at 17:53 — Rahul
– Rahul, Commented Jan 9, 2016 at 17:53

Rahul · Accepted Answer · 2016-01-09 17:57:23Z

1

Problem is FOR INSERT AS. It should BEFORE INSERT AS. Check MySQL Documentation for CREATE TRIGGER syntax. Looks like you mixed up SQL Serer syntax. For Trigger is MSSQL syntax.

CREATE
    [DEFINER = { user | CURRENT_USER }]
    TRIGGER trigger_name
    trigger_time trigger_event
    ON tbl_name FOR EACH ROW
    [trigger_order]
    trigger_body

trigger_time: { BEFORE | AFTER }

trigger_event: { INSERT | UPDATE | DELETE }

answered Jan 9, 2016 at 17:57

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

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

Comments

pvc · Accepted Answer · 2016-01-09 18:29:59Z

0

You should name the triggers using the following naming convention:

(BEFORE | AFTER)_tableName_(INSERT| UPDATE | DELETE)

for example after_tableName_insert

Refer below tutorial for creating triggers. http://www.mysqltutorial.org/mysql-trigger-implementation.aspx

answered Jan 9, 2016 at 18:29

pvc

1,1901 gold badge9 silver badges14 bronze badges

Collectives™ on Stack Overflow

Trigger error in mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related