KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
It's my understanding that when you call last_insert_id() it goes by connections, so you'll get the id of the last row inserted on the same connection where last_insert_id() is called, right? So what if I call last_insert_id() in an 'AFTER INSERT' trigger? What I want to do is basically this DELIMITER $$ CREATE TRIGGER sometrigger AFTER INSERT ON sometable BEGIN INSERT INTO anothertable (id, lastup) VALUES (last_insert_id(), NOW()); END $$ It's very important that the id in 'anothertable' is the same as in 'sometable' Would this work or should I create a stored procedure instead that inserts into both tables? Or possibly there is some, in the trigger, to get the values from the insert statement that caused the trigger to fire? I haven't found anything about that.
Tags (comma-separated)
Save Edits
Cancel