How to get current date & time in MySQL?

Question

In MySQL, Is there any command or value like DATETIME which I can use it in a manual query for inserting the current date and time?

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

I need to add the current date and time in the quoted DATETIME value at the ending 

Answer 1

For adding current date and time, you can use NOW():

INSERT INTO servers (server_name, online_status, exchange, disk_space, network_shares, c_time)
VALUES('m1', 'ONLINE', 'exchange', 'disk_space', 'network_shares', NOW())

Want to know more about SQL? Join this SQL Course by Intellipaat.

For more details on MySQL, refer to the below MySQL Tutorial video.