How to get current date & time in MySQL?

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())

Use CURRENT_TIMESTAMP() or now()

Like

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

or

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

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

Even though there are many accepted answers, I think this way is also possible:

Create your 'servers' table as following :

CREATE TABLE `servers`(      id int(11) NOT NULL PRIMARY KEY auto_increment,      server_name varchar(45) NOT NULL,      online_status varchar(45) NOT NULL,      _exchange varchar(45) NOT NULL,       disk_space varchar(45) NOT NULL,      network_shares varchar(45) NOT NULL,      date_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP);

And your INSERT statement should be :

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

My Environment:

Core i3 Windows Laptop with 4GB RAM, and I did the above example on MySQL Workbench 6.2 (Version 6.2.5.0 Build 397 64 Bits)