Newbie MySQL Table update trigger.
Hi
Am new the whole SQL thing. Am more of a Ms Access but studying the feature, advantages and pros of MySQL i was impressed with it.
Said so i am planing to move our department Access Database to MySQL. So far i've managed to migrate the existing access db to MySQL on a test environment.
My question regarding MySQL how can i update a column in a table after it is inserted or is there a way to display the primary key (from Access forms) before the record saved ?
If inserting i need to check for a few conditions before inserting
IF DRID_FK = NULL THEN DelID_FK = DelID (this ID should be form the previous record) Else <nothing>
Subject
Written By
Posted
Newbie MySQL Table update trigger.
February 14, 2016 04:55AM
February 15, 2016 01:36AM
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.