[an error occurred while processing this directive]

MySQL Column Type Database

In this session you will learn how to support number of column in MySQL . MySQL supports the numeric type , Date and time type, and String type (char) database.

MySQL Numeric type and String type Database :

TYPE	BYTE	MINIMUM VALUE	MAXIMUM VALUE
TINYINT	1 Byte	-128	127
BIT	(M+7)/8 Byte	-	-
SMALLINT	2 Byte	-32768	32767
MEDIUMINT	3 Byte	-8388608	8388607
INT(M) (UNSIGNED) (ZEROFILL)	4 Byte	-2147483648	2147483647
INTERGER [M]	4 Byte	-	-
BIGINT [M]	8 Byte	`-9223372036854775808`	`9223372036854775807`
FLOAT [precision]	4 Byte
FLOAT [(M, D)]	8 Byte
DOUBLE [(M,D)]	8 Byte
DOUBLE precision [(M, D)]	8 Byte	-1.7976931348623157E+308 to-2.2250738585072014E-308, 0,	2.2250738585072014E-308 to 1.7976931348623157E+308
REAL [(M, D)]	8 Byte
DECIMAL [(M ,D)]	M+2 Byte	-999.99	999.99
NUMERIC[(M,D)]	M+2 Byte
VARCHAR	L+1 Byte	0	255
CHAR	M Byte	0	255
TINYBLOB	L+1 Byte	0	256
TINYTEXT	L+1 Byte	0	255 (2^8-1) Char
BLOB OR TEXT	L+2 Byte	0	65,535 (2^16-1)char
MEDIUMBLOB	L+3 Byte	-	16,777,215(2^24-1)char
MEDIUMTEXT	L+3 Byte	-	16,777,215(2^24-1)char
LONGBLOB	L+4 Byte	-	4,294,967,295(2^32-1)char
LONGTEXT	L+4 Byte	-	4,294,967,295 or 4GB
ENUM ('value1, value2',..)	1 or 2 Byte	0	65,535
SET ('value1,' value 2,' .....)	1 to 8 Byte	0	64

MySQL Store the Date and Time Type

Column Type	Store Data
DATE	3 Byte
DATETIME	8 Byte
TIMESTAMP	4 Byte
TIME	3 Byte
YEAR	1 Byte

Facing Programming Problem? Ask Questions? Browse Latest Questions Question-Answer Guidelines
Add This Tutorial To:
Del.icio.us	Digg	Google	Spurl	Blink	Furl	Simpy	Y! MyWeb

Current Comments

0 comments so far (post your own) View All Comments Latest 10 Comments:

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.

  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification

Browse all Java Tutorials

Java New to Java? Learn Java In A Day Learn Java Quickly Java Tools Beginners Java Tutorial Master Java Tutorial (TOC) Java IO Package Examples Java AWT Package Examples Swing Example Java util Examples Java Programming	JSP Introduction to JSP JSP Architecture Introduction to the JSP tags Features of JSP 2.1 JSP Fundamentals	Struts Introduction to the Apache Struts Struts Architecture Introduction to the Struts Controller Introduction to Struts 2 Struts 2 Features Struts 2 History	Servlets History of Web application Introduction to Web Server What is servlet? Methods of Servlet Advantages of Java Servlets	Hibernate Introduction to Hibernate 3.0 Hibernate Architecture Hibernate Update Query Hibernate Count Query Hibernate Projections	XML XML : An Introduction XML: An Introduction - Brief History XML:Validation Introduction to DTD DTD:Document Type Definition
Ajax What is Ajax? Ajax Code Libraries and Tools Ajax Login Example	JDBC What is JDBC? JDBC Driver and Its Types Features of JDBC 3.0	EJB Introduction to Application Server Features of EJB 3.0 Message Driven Beans	MySQL Introduction to MySQL Installing MySQL on Windows MySQL Configuration	JavaScript What is JavaScript? Statements In JavaScript Functions in JavaScript	JSF Introduction To JSF JSF Releases JSF Features
Maven2 Tutorial An introduction to Maven 2 Maven 2: Features Maven 2 Eclipse Plug-in	JEE5 Tutorial Understanding JEE technologies JEE 5 API Deploying Application	Java Threading Tutorial Overview of Thread Thread Creation Daemon Thread	Photoshop Tutorials How to design a express realization mode How to design a table lamp	Linux Linux Tutorials Linux CDs Linux Distributions Free Linux CDs	Technology GPS WiMAX VoIP WiFi HSDPA Tech. What is?
Technology Revolutions Rich Internet Application Web 2.0 Web 3.0 JavaFX	Eclipse About IDE Creating a Project	Spring Tutorial Introduction to the Spring Framework	Bioinformatics Tutorials History of Bioinformatics	Tools Junit Jmeter DBUnit	SQL SQL: A brief Introduction Create a database

About Us | Advertising On RoseIndia.net | Site Map

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.