Cannot create trigger in mysql because of #1193 error code

Question

I want to create a trigger:

CREATE TRIGGER before_insert_klienci
BEFORE INSERT ON `klienci`
FOR EACH ROW
SET `id` = uuid()

Unfortunately I got:

#1193 - Unknown system variable 'id'

I am completely sure that a column id exists and I have no typo.

Any ideas?

Have a good day, Przemek

Joachim Isaksson · Accepted Answer · 2014-04-27 18:32:31Z

2

You want the new row updated with the UUID, so you just need to tell the trigger where to find the id value you want updated;

CREATE TRIGGER before_insert_klienci
BEFORE INSERT ON `klienci`
FOR EACH ROW
SET NEW.`id` = uuid();

answered Apr 27, 2014 at 18:32

Joachim Isaksson

182k28 gold badges297 silver badges307 bronze badges

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

1 Answer 1