MySQL Create trigger for get value from another column

Question

i have a table which contains columns as "barkoda1,barkoda2,barkoda3,@pdfa1,@pdfa2,@pdfa3", what i'm trying to do is when a record assigned to barkoda1 copy same record to @pdfa1,for example if barkoda1 defined as "1234567890" @pdfa1 should be "1234567890.pdf".

i tried to create a trigger for it, but failed;

DELIMITER //
CREATE TRIGGER pdfdeneme AFTER INSERT
ON finyeb_ba_2369_bio_for_2__r_d_
FOR EACH ROW
BEGIN
  UPDATE finyeb_ba_2369_bio_for_2__r_d_ SET `@pdfa1`=NEW.barkoda1;
END//
DELIMITER ;

when i create this trigger,it doesn't return any error but when i add record to table mysql returns "it is already used by statement which invoked this stored function/trigger".

also tried this way

DELIMITER //
CREATE TRIGGER pdfdeneme BEFORE INSERT
ON finyeb_ba_2369_bio_for_2__r_d_
FOR EACH ROW
BEGIN
  INSERT INTO finyeb_ba_2369_bio_for_2__r_d_(`@pdfa1`) VALUES(NEW.barkoda1);
END//
DELIMITER ;

But same error happened, what am i doing wrong here?

You only need the set part of the statement..with a concat for the .pdf part — P.Salmon
– P.Salmon, Commented Oct 8, 2020 at 14:36

nbk · Accepted Answer · 2020-10-08 15:06:27Z

1

You need a BEFORE INSERT TRIGGER

And then only use the SET Clause

DELIMITER //
CREATE TRIGGER pdfdeneme BEFORE INSERT
ON finyeb_ba_2369_bio_for_2__r_d_
FOR EACH ROW
BEGIN
  SET NEW.`@pdfa1` =  CONCAT(NEW.barkoda1,'.pdf');
END//
DELIMITER ;

But your column name is a bad choice, it leads on the first glance to false conclusions.

edited Oct 8, 2020 at 15:06

answered Oct 8, 2020 at 14:55

nbk

49.6k8 gold badges32 silver badges53 bronze badges

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

1 Comment

Sheshman Over a year ago

you are right about column name,unfortunately it's not my design,i need to continue over it and that column names causing problem all the time, thanks for your help.

Collectives™ on Stack Overflow

MySQL Create trigger for get value from another column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related