var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Newbie MySQL Table update trigger.
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>