mysql tuterials class 6(i) mysql datatypes скачать в хорошем качестве

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