Answers for "timestamp mysql insert"

SQL
1

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.
Posted by: Guest on April-07-2021
-1

sql syntax create timestamp column

CREATE TABLE tablename (columnname datetime NOT NULL DEFAULT CURRENT_TIMESTAMP)
Posted by: Guest on June-11-2020

Code answers related to "timestamp mysql insert"

Code answers related to "SQL"

Browse Popular Code Answers by Language