mysql tuterials class 6(i) mysql datatypes

Описание: 1/01/26
today class
=========
MySQL data types
==================
datatype:
========
in MySQL datatype is that refering the data in a table or a field,just like String ,int decimal etc;
manually type of data is 3
where that numerica,data and time and finally String.
Ex:
sno int;
these are classifield into 5 types
1)int
======
it simply say that we store in a column (field ) of a table only we store numerial values like numbers
in a column we store a num type data we refer int datatype
Attr: auto_increment,not null
where the range of int
int=4byte
length of 2147483648

semi int types also but we are not using
*tyniint
*miniint
*medium
*longint
2) varchar
===========
it is defined as that storing data in a field or a table for String type like character type.
we store datatype char or varchar also even that time we init length of the variable also beacuase with out writing length it wont work out it.
range of char is 0 t0 65 535.exceed so that
BLOB:
=======
is stands for binary lorge object we store data such as ing,video ectc
3)decimal
==========
it stores for double values mostly we used salary relted
attr:
(p,d)p we strore 0 to 65 ,d is o to 30
4)Enum:
======
combinational data we store in a table such that in a btech using many groups where ece,cse,it we use enum
5)float
========
it just like decimal type and we float values in a table approximate values stored that we used float