how to insert timestamp in mysql code example

Example 1: how to add timestamp column in mysql

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

Example 2: add current timestamp in mysql

INSERT INTO servers (server_name, online_status, exchange, disk_space,
network_shares,date_time) VALUES('m1','ONLINE','ONLINE','100GB','ONLINE',now() )

#Replace date_time with the column name you want to use to insert the time.