Re: Confused on Triggers and Store Procedures

[Peter Brawley]

To get the last auto_increment value used, call last_insert_id().

You can't call UPDATE on `pen` in a Trigger on pen.

And isn't there a typo: aren't you trying to set location_id? So ...

set new.location_id = last_insert_id();