Check out example codes for "mysql create timestamp column". 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