Shulou(Shulou.com)06/01 Report--

How to insert a date in MySQL? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

MySQL provides several data types for storing dates in its database system: DATE,TIMESTAMP,DATETIME and YEAR.

How to use date statement

The default way to store dates in the MySQL database is to use DATE. The correct format for DATE is: YYYY-MM-DD. If you try to enter a date in a format other than the year-month-day format, it may work but will not store the date as expected.

To run the MySQL Insert command and add the current date to the table, you can use MySQL's built-in function CURDATE () in the query.

An example of inserting a date in MySQL using CURDATE

$query_auto = "INSERT INTO tablename (col_name, col_date) VALUE ('DATE: Auto CURDATE ()', CURDATE ())"

In addition, you can run a query to set the date manually

An example of how to insert a date manually in MySQL

$query_manual = "INSERT INTO tablename (col_name, col_date) VALUES ('DATE: Manual Date',' 2019-7-04')"

All of these queries can be run using the command line, scripting (written in PHP,Perl,Python, etc.), or through the PHPMyAdmin interface in NTC Hosting's complex Web managed control panel.

In addition, there is a declaration that allows you to set only the year of the event. Year statements are in YYYY format, ranging from 1901 to 2155 (for years beyond this range, you need to use the date statement)

Thank you for reading! After reading the above, do you have a general idea of how to insert dates in MySQL? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.