DATA TYPES IN SQL:
1) NUMERIC
2) DATE AND TIME
3)STRING TYPES
NUMERIC:
#INT : NORMAL SIZED INTEGER WHICH CAN BE SIGNED OR UNSIGNED. SPECIFY WIDTH UPTO 11 DIGITS.
#FLOAT : A FLOATING POINT NUMBER THAT CANNOT BE UNSIGNED. BY DEFAULT IT IS 10,2 THAT IS 2 IS THE NUMBER OF DECIMALS AND 10 IS THE TOTAL NUMBER OF DIGITS(INCLUDING DECIMALS). DECIMAL PRECISION CAN GO TO 24 PLACES FOR A FLOAT.
DATE AND TIME:
#DATE : A DATE IN YYYY-MM-DD FORMAT.
#DATETIME : A DATE AND TIME COMBINATION IN YYYY-MM-DD HH:MM:SS.
#TIME : TIME IN HH:MM:SS.
STRING:
#CHAR : FIXED LENGTH STRING BETWEEN 1 AND 255 CHARACTERS.
#VARCHAR : VARIABLE LENGTH STRING BETWEEN 1 AND 255 CHARACTERS.
