What does sql integer mean?

integer in sql means "integer, integer number", which represents the integer type, including negative integers, zero and positive integers, allowing numbers between "-32,768" and "32,767"; can be used Specify the data type of a field in the data table, for example "create table test (id integer);".

integer in sql represents the integer type, including negative integers, zero and positive integers; it can be used to specify the data type of a field in the data table.

Integer type, allows numbers between -32,768 and 32,767; 2 bytes.​

Example: When creating a table,

create table test (id integer);

means that the id field is of integer type. In the id field, only integers can be accessed.

Extended information:

In mysql, fields of type int (or Integer, the keyword INT is a synonym for INTEGER) allow access (-2 147 483 648, 2 147 483 647).

The above is the detailed content of What does sql integer mean?. For more information, please follow other related articles on the PHP Chinese website!