For a code which bosses can help see

CodePudding user response:

1 kind is to write a trigger: add a trigger on gg table, every time a new data in gg table automatically update the inventory list,

Two is to write a stored procedure or statement, through the existing gg table, to update the stock table, but gg table to do mark, updated and to update,

CodePudding user response:

reference 1/f, Yole response:

1 kind is to write a trigger: add a trigger on gg table, every time a new data in gg table automatically update the inventory list,

Two is to write a stored procedure, or statements by existing gg table, to update the stock table, but gg table to do mark, updated and for updating,

ok thank you