MySQL Forums
Forum List  »  Triggers

Re: Autoincrement ID copied by trigger
Posted by: Dave Banthorpe
Date: March 31, 2015 02:50AM

I've even tried moving the trigger to BEFORE_INSERT but alas no change in behaviour. The reason I need this to work is that I have another table that I will place a similar trigger on so there will be 2 source tables writing, via TRIGGERS, to the target table so the target table needs to control it's own primary key/auto increment.

Options: ReplyQuote

Written By
Re: Autoincrement ID copied by trigger
March 31, 2015 02:50AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.