First, MySQL data type:

In MySQL, there are three main types: Text, Number and Date/Time.

1, text type.

2, number type. These integer types have additional unsigned options. Generally speaking, integers can be negative or positive. If you add an unsigned attribute, the range will start from 0 instead of some negative number.

3. Date type.

Although DATETIME and TIMESTAMP return the same format, they work in very different ways. When inserting or updating a query, TIMESTAMP automatically sets itself to the current date and time.

TIMESTAMP also accepts different formats, such as YYYYMMDDHHMMSS, YYMMDDHHMMSS, YYYYMMDD or YYMMDD.

Second, the SQL Server data type:

1, string type.

2, number type.

3. Date type.

4. Other data types.

Extended data:

Data type of Microsoft Access:

References:

Baidu encyclopedia-SQL data type