Answer Posted / Santosh Kumar Bhart
To declare a variable inside a MySQL trigger, you can use the DECLARE keyword followed by the variable name and data type. For example: 'CREATE TRIGGER my_trigger BEFORE INSERT ON my_table FOR EACH ROWn BEGINn DECLARE new_id INT;n SET new_id = (SELECT LAST_INSERT_ID());n END;'.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
