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

This article mainly introduces "what is the MySQL date type and default setting". In daily operation, I believe many people have doubts about MySQL date type and default setting. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "MySQL date type and default setting". Next, please follow the editor to study!

How does the date type of MySQL set the default value to the current system time?

Currently, you can only use the timestamp type, and the default value is set to now () or current_timestamp () / CURRENT_TIMESTAMP.

There are five date types of MySQL: date, time, year, datetime, timestamp

Whether the type byte format purpose supports setting system default date3YYYY-MM-DD date value does not support time3HH:MM:SS time value or duration does not support year1YYYY year does not support datetime8YYYY-MM-DD HH:MM:SS date and time mixed value does not support timestamp4YYYYMMDD HHMMSS mixed date and time, can be used as a timestamp to support date type default setting method 1:

CreateTime timestamp NOT NULL DEFAULT NOW ()

Method 2:

CreateTime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP (); method 3: createTime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP

According to the above table, except that the timestamp type supports the system default setting, other types do not support it.

If the table statement contains:

CreateTime time NOT NULL DEFAULT NOW ()

CreateYear year NOT NULL DEFAULT NOW ()

CreateDate date NOT NULL DEFAULT CURRENT_TIMESTAMP ()

CreateDatetime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ()

Will report the wrong message. So if you want to set the default value of a date column to the current time, you can only use the timestamp type and set DEFAULT NOW (), DEFAULT CURRENT_TIMESTAMP (), and DEFAULT CURRENT_TIMESTAMP as the default values.

At this point, the study on "what are the MySQL date types and default settings" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.