How Can I Easily Insert the Current Date and Time into MySQL?

Fetching Current Date and Time in MySQL

Manually inserting the current date and time into a database can be a cumbersome task. MySQL offers an elegant solution to this problem with the NOW() function.

Question: Is there a simple way to insert the current date and time into a MySQL database?

Answer:

Yes, you can use the NOW() function to effortlessly add the current date and time to your database entries. By incorporating NOW() into your SQL INSERT statement, you can automatically populate the relevant field with the current datetime value.

Consider the following example:

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

In this statement, the NOW() function automatically inserts the current date and time into the c_time field. This ensures accurate and up-to-date timestamps without any manual input.

The above is the detailed content of How Can I Easily Insert the Current Date and Time into MySQL?. For more information, please follow other related articles on the PHP Chinese website!