Friday 10, February 2012
Welcome Guest, Register | Login  
      Home    |    Tutorials    |    Free Ebooks    |    Free Scripts    |    Articles    |    Blog     |    Forum    |    About Us    |    Contact Us

MySQL Data Types

Numeric Data Types:
TINYINT( )
-128 to 127 normal
0 to 255 UNSIGNED.
SMALLINT( )
-32768 to 32767 normal
0 to 65535 UNSIGNED.
MEDIUMINT( )
-8388608 to 8388607 normal
0 to 16777215 UNSIGNED.
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.

 

TEXT TYPES
CHAR( )
Fixed section from 0 to 255 characters long.
VARCHAR( )
Variable section from 0 to 255 characters long.
TINYTEXT
String with a maximum length of 255 characters.
TEXT
String with a maximum length of 65535 characters.
BLOB
String with a maximum length of 65535 characters.
MEDIUMTEXT
String with a maximum length of 16777215 characters.
MEDIUMBLOB
String with a maximum length of 16777215 characters.
LONGTEXT
String with a maximum length of 4294967295 characters.
LONGBLOB
String with a maximum length of 4294967295 characters.

 

Date Data Types:
DATE
YYYY-MM-DD.
DATETIME
YYYY-MM-DD HH:MM:SS.
TIMESTAMP
YYYYMMDDHHMMSS.
TIME
HH:MM:SS.

 

MISC Types
ENUM ( )
ENUMERATION means that each column may have one of specified possible values.
SET
SET is similar to ENUM. However, SET can have up to 64 list items and it can store more than one choice

 


 
     
   
PHP Tutorial
 
  Introduction
Introduction
  Variables
Variables
  Strings
Strings
  Operators
Operators
  If Else Statement
If Else Statement
  Loops
Loops
  Functions
Functions
  Forms
Forms
  Sessions
Sessions
  Cookies
Cookies
  Files
Files
  E-mail
E-mail
  Error Handling
Error Handling
  File Upload
File Upload
  PHP Databases
PHP Databases
  Connecting to a MySQL Database
Connecting to a MySQL Database
  MySQL Data Types
MySQL Data Types
  Inserting Data Into a Table
Inserting Data Into a Table
  Select Statement
Select Statement
  Where Clause
Where Clause
  Order By
Order By
  Update Statement
Update Statement
  Delete From Statement
Delete From Statement
 
 
 
Web Designing Tutorials
  HTML Tutorial
HTML Tutorial
  DHTML Tutorial
DHTML  Tutorial
  CSS Tutorial
CSS Tutorial
  XHTML Tutorial
XHTML Tutorial
 
Programming Languages Tutorials
  C Language Tutorial
C Language Tutorial
  C++ Tutorial
C++ Tutorial
  Java Language Tutorial
Java Language Tutorial
  Data Structure Theory Tutorial
Data Structure Theory Tutorial
 
Server Side Scripting Tutorials
  PHP Tutorial
PHP Tutorial
  SQL Tutorial
SQL Tutorial
  ASP Tutorial
ASP Tutorial
 
Client Side Scripting Tutorials
  JavaScript Tutorial
JavaScript Tutorial
  VBScript Tutorial
VBScript Tutorial
 
 
 
POPULAR E-BOOKS
 
Download Article Marketing Success Ebook Article Marketing Success
   
Download How to use targeted social networks to reach people of influence and get viral e Ebook How to use targeted social networks to reach people of influence and get viral e
   
Download 10 Website Traffic Tips  Ebook 10 Website Traffic Tips
   
Download Market Yourself Professionally  Ebook Market Yourself Professionally
   
Download GDI Star Plan Ebook GDI Star Plan
   
 
Studiesinn.com © 2012 All Rights Reserved.
Website Designed & Developed by TechXprtz