What are the common data types of data tables?

Common data types of data tables include: integer type, floating point type, date and time type, string type, binary type, and Boolean type.

Integer type:

1. Int type: is an integer composed of four bytes , output range (-2147483 648~2 147 483 647)

2. bigint type: an integer composed of eight bytes, output range (-9,223,372,036,854,775,808~9 223 372 036 854 775 807)

3. Tinyint type: Only integers between (0~225) can be input

4. Smallint type: It is an integer composed of two bytes, and the output range is (-32768~32767)

Floating point type:

3. float: represents single-precision floating point value

2. double: represents double Precision floating point value

String type:

1, charchar (n): fixed length, up to 255 characters

2. varchar(n): fixed length, up to 65535 characters

3. text: variable length, up to 65535 characters

4. tinytext: variable length, up to 255 characters

5, mediumtext: variable length, up to 2 to the 24th power - 1 character

6, longtext: variable length, up to 2 to the 32nd power - 1 character

Binary type:

varbinary(max), binary(max)

Boolean type :

Sometimes you just need to store something that is "yes" or "is not". It can be set to Boolean type.

boolean: There are three states: 1 (indicating TRUE), 0 (indicating FALSE) or NULL.

Date and time types:

1. Data type: represents date value, format is (YYYY-MM-DD), range ( 1000.1.1~9999.12.31)

2. Datatime type: represents mixed date and time values, the format is (YYYY-MM-DD HH:MM:SS), the range is (1000.1.1 00:00: 00~9999.12.31 23:59:59)

3. Time type: represents a more precise time value or duration, the format is (HH:MM:SS), the range is (-838:59:59' ~'838:59:59')

4. Year type: represents the year value, the format is (YYYY), range (1901~2155)

5. Timestamp type: automatically stores records Modification time (if there is a timestamp data type in the database, time zone issues should be considered)

The above is the entire content of this article, I hope it will be helpful to everyone's learning. For more exciting content, you can pay attention to the relevant tutorial columns of the PHP Chinese website! ! !

The above is the detailed content of What are the common data types of data tables?. For more information, please follow other related articles on the PHP Chinese website!