shilpak10

 Profile Answers by shilpak10 Questions by shilpak10

• Mar 28th, 2007

 

DATA TYPES in mysql varchar => 

A variable section from 0 to 255 characters long. 

tinyint => A string with a maximum length of 255 characters. 

text => A string with a maximum length of 65535 characters. 

date => YYYY-MM-DD. 

smallint mediumint int => 	-2147483648 to 2147483647 normal 0 to 4294967295 UNSIGNED. 

bigint => 	-9223372036854775808 to 9223372036854775807 normal 0 to 18446744073709551615 UNSIGNED. 

float => A small number with a floating decimal point.

 double => A large number with a floating decimal point.

 decimal => A DOUBLE stored as a string , allowing for a fixed decimal point.

 datetime => YYYY-MM-DD HH:MM:SS. timestamp => YYYYMMDDHHMMSS.

 time => 	HH:MM:SS. year 

char => CHAR( )	A fixed section from 0 to 255 characters long. 

tinyblob tinytext

 blob => A string with a maximum length of 65535 characters.BLOB stands for Binary Large OBject. 

mediumblob => A string with a maximum length of 16777215 characters. 

longblob => A string with a maximum length of 4294967295 characters.

 longtext enum => Short for ENUMERATION which means that each column may have one of a specified possible values.

 set => Similar to ENUM except each column may have more than one of the specified possible values. bool binary varbinary

sampra

 Profile Answers by sampra 

• Mar 10th, 2008

 

int varchar char date double long etc are available for mysql

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed 

• Jun 29th, 2011

 

Hi,

MySQL supports following data types:


Hi,

Numerical type
String type
Date and time type

If you need further clarification or discussion please mail me at altafhsayyed@yahoo.com

Thanks and regards

Bhagya Killi

 Profile Answers by Bhagya Killi 

• Jun 14th, 2016

 

1.Numeric Datatype
2.Date and Time Datatype
3.String Datatype

raja

• Jul 7th, 2017

 

Int, Char, Varchar, double, float, etc..