Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 579
  • Last Modified:

How to add mysql insert trigger

I need to create a a record in tblOrderStatus everytime a record is INSERTED in tblOrders.  I have a bit so far but my big question is how do I insert the tblOrder.id into tblOrderStatus with my trigger?


DELIMITER $$
CREATE TRIGGER after_orderPlaced
AFTER INSERT ON tblOrders
FOR EACH ROW
BEGIN

    INSERT INTO tblStatus
    SET tblLastTime = ADDTIME(Curtime(),'2:00:00'),
            tblLastDate = Curdate()
            tblOrderId = ??????????????
END
0
drhamel69
Asked:
drhamel69
1 Solution
 
Chris StanyonCommented:
You use the NEW keyword:

DELIMITER $$
CREATE TRIGGER after_orderPlaced
AFTER INSERT ON tblOrders
FOR EACH ROW BEGIN
   INSERT INTO tblStatus
   SET tblLastTime = ADDTIME(Curtime(),'2:00:00'),
   tblLastDate = CURDATE(),
   tblOrderId = NEW.id;
END$$
DELIMTER;

Open in new window

0
 
drhamel69Author Commented:
Excellent!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now