Hello! I have a table with the name tabx and two columns y and z, when I will insert the values in the column and I need a trigger to copy this value to the z-column. Have I tried some solutions but unsuccessfully can someone help me?
Hello! I have a table with the name tabx and two columns y and z, when I will insert the values in the column and I need a trigger to copy this value to the z-column. Have I tried some solutions but unsuccessfully can someone help me?
+ or- this
CREATE TRIGGER ins_table BEFORE INSERT ON table FOR EACH ROW BEGIN SET NEW.z = new.y; END; //