MySQL Trigger
I have created a trigger that is working as expected
the table tbl_comments also has a column D_ID, How do i include the D_ID value into tbl_service_log
CREATE DEFINER=`root`@`%` TRIGGER trg_DDAI_Service
AFTER INSERT ON tbl_comments
FOR EACH ROW BEGIN
INSERT INTO tbl_service_log
SET DDAI_ServicesID = '1',
DDAI_Services_Date = NOW();the table tbl_comments also has a column D_ID, How do i include the D_ID value into tbl_service_log
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ray Paseur
No points for this, but you might want to learn about the TIMESTAMP column definition.
ASKER
Thanks
You are welcome - thanks for the points.