更新链接表时更新日期时间

Question

I have 2 tables, let's call it computer_set and item_info.

This is the computer_set sample data, as you can it has the name and description` of the set of computers

The table above is linked to item_info table via cartTemplateNameIDcolumn as you can see below.

My question is I would like to update the lastModified row on computer_set table whenever I updated any information in item_info. For example, if I add another item in item_info and linked it to computer_set it will automatically update the lastModified column of computer_set because a new item has been added to the group.

Answer 1

You probably want to use MySQL triggers.