SQL DATA TYPES

CHAR(LENGTH):STRING

VARCHAR(LENGTH):STRING OF VARIBLE LENGTH

TEXT: TEXT OF 64KB

INT(LENGTH):INTEGER OF 10 DIGITS LENGTH

BIGINT(LENGTH):INTEGER OF 19 DIGITS LENGTH

DECIMAL(LENGTH, DECIMAL): DECIMAL NUMBERS . YOU CAN SPECIFY LENGTH OF NUMBERS AND SIZE

UNSIGNED: IF UNSIGNED IS USED WITH NUMBERS IT TAKES ONLY POSITIVE NUMBERS

SERIAL: AUTOINCREMENT NUMBERS

ENUM(VAL1,VAL2,..): ENUMERATE VALUES

DATE: TAKES DATA IN YYYY-MM-DD FORMAT

TIME: TAKES TIME IN HH:MM:SS FORMAT

DATETIME: TAKES BOTH DATE AND TIME

Posted via Blogaway