What are different data types to manage data in the columns or fields?

Every column or field related to some entity has to manage a kind of data known as data type.

In general, data can be of three types

·         Numeric type Data

·         String type Data

·         Date type Data

Different RDBMS software provides different keywords to define the data type e.g.

MySQL provides data types such as

·         INT for integer data numeric data e.g. Book Number

·         FLOAT for floating type numeric data e.g. Price

·         VARCHAR for variable length strings e.g. Name, Email

·         CHAR for fixed length strings e.g. Pin Code, Mobile Number

·         DATE for managing dates e.g. Date of Birth

Remember that,

ü      While defining the string data types like CHAR and VARCHAR, we need to specify the maximum number of character to be allowed to insert that column or field

ü  Don’t use the space while defining the column or field names e.g. Book Number should be written as BookNumber