Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "mysql data types are mainly divided into several types". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

MySQL data type

In MySQL, there are three main types: text, number, and date / time types.

Number type:

* these integer types have an additional option, UNSIGNED. In general, integers can be negative or positive. If you add the UNSIGNED attribute, the range starts at 0, not a negative number.

Date type:

* even if DATETIME and TIMESTAMP return the same format, they work very differently. In an INSERT or UPDATE query, TIMESTAMP automatically sets itself to the current date and time. TIMESTAMP also accepts different formats, such as YYYYMMDDHHMMSS, YYMMDDHHMMSS, YYYYMMDD, or YYMMDD.

This is the end of the content of "there are several main mysql data types". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.