Create My sql trigger for After insert , update another table column using inserted record

Asked Oct 16 '19 at 17:59

Active Oct 16 '19 at 18:02

Viewed 15 times

CREATE TRIGGER latest_user_task_status_trigger AFTER INSERT ON
    user_task_transaction_table FOR EACH ROW
BEGIN
    UPDATE
        user_task_table
    SET
        user_task_table.user_task_status=NEW.user_task_status
    WHERE
        user_task_table.id = NEW.user_task_id;
END

I have created above query but it gives me following error

How can i resolve that.

edited Oct 16 '19 at 18:02

Dharman

30,962
25
85
135

asked Oct 16 '19 at 17:59

Thushara

1

You forgot to use `DELIMITER` before this, to allow you to use `;` inside the trigger. – Barmar Oct 16 '19 at 18:01
Since there's only one statement in the trigger, you don't need `BEGIN` and `END`. – Barmar Oct 16 '19 at 18:01
@Barmar how to add that DELIMITER in my query – Thushara Oct 16 '19 at 18:04
1

You just type it before the query. `DELIMITER $` – Barmar Oct 16 '19 at 18:05
1

Read the duplicate question I linked to. – Barmar Oct 16 '19 at 18:05
it gives me #1419 - You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) @Barmar – Thushara Oct 16 '19 at 18:10
1

That's a completely unrelated problem. – Barmar Oct 16 '19 at 18:15
If you're using Amazon RDS, it's probably [this problem](https://stackoverflow.com/questions/11601692/mysql-amazon-rds-error-you-do-not-have-super-priviledges) – Barmar Oct 16 '19 at 18:16

Create My sql trigger for After insert , update another table column using inserted record

0 Answers0