Check out example codes for "create table with timestamp mysql youtube". It will help you in understanding the concepts better.

Code Example 1

ALTER TABLE `table1` ADD `lastUpdated` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ;

Learn ReactJs, React Native from akashmittal.com