mysql insert current timestamp code example

Example 1: store sysdate in row phpadmin

CURDATE() #Format -> yyyy-mm-dd
  or
NOW() #Format -> yyyy-mm-dd HH:MM:SS

Example 2: mysql insert datetime

-- If you just need to insert the current DateTime: --
INSERT INTO yourtable (`DateTimeFieldName`) VALUES (NOW());

Example 3: 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.