What are the types of data in SQL?

In Generic,

Integer

Varchar

Numeric

Decimal

DateandTime

There are three main data types: text, number, and date.

1) CHARACTER [(length)] or CHAR [(length)]

2) VARCHAR (length)

3) BOOLEAN

4) SMALLINT

5)INTEGER or INT

6) DECIMAL [(p[,s])] or DEC [(p[,s])]

7) NUMERIC [(p[,s])]

8) REAL

9) FLOAT(p)

10) DOUBLE PRECISION

11) DATE

12) TIME

13) TIMESTAMP

Threre ara several types of data in SQL, and it's important to understand the uses and particularities of each type of data, in order to choose the best possible type when you define the columns of your tables. Choosing the wrong kind of data could lead to critical situations such as: a waste of memory, performance problems.

Each DBMS has its own data types, the following types are used by the MySQL :

1 Numeric types : numeric types can be subdivided into two sub-categories: integers, and decimals.

Integers : INT, TINYINT, SMALLINT, MEDIUMINT and BIGINT.

Decimals : DECIMAL, NUMERIC, FLOAT, REAL and DOUBLE.

2 Alphanumeric types : CHAR, VARCHAR and TEXT.

3 Time Types : DATE, DATETIME, TIME, TIMESTAMP and YEAR.

Best regards,

Younes LABIOD