logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
European Travel
Action Movies
Bible Basics
Houseplants
Romance Movies
Creativity
Family Travel


dailyclick
All times in EST

Full Schedule
g
g PHP Site

BellaOnline's PHP Editor

g

MySQL Data Types - Most Frequently Used

Guest Author - Diane Cipollo

MySQL Data Types

CHAR(length)
Character string with a fixed length which is the number between the ( )

VARCHAR(length)
Character string with a variable length. The maximum is the number between the ( )

TEXT
Variable character string that can be up to 64 kb

INT(length)
Integer which can be any number between -2147483648 to 2147483647
The number between the ( ) is the maximum length (digits) of the number that will be displayed even though the stored number might be longer

INT(length) UNSIGNED
Integer which can be any number between 0 to 4294967295
The number between the ( ) is the maximum length (digits) of the number that will be displayed even though the stored number might be longer
Integer cannot be a negative number

DECIMAL(length, dec)
Decimal number with a display length between the ( )
dec is the maximum number of decimal places

DATE
Date stored in the YYYY-MM-DD format

TIME
Time stored in the HH:MM:SS format

DATETIME
Date and time stored in the YYYY-MM-DD HH:MM:SS format

PRIMARY KEY
The field that is the unique ID for the record




This site needs an editor - click to learn more!

Add MySQL+Data+Types+%2D+Most+Frequently+Used to Twitter Add MySQL+Data+Types+%2D+Most+Frequently+Used to Facebook Add MySQL+Data+Types+%2D+Most+Frequently+Used to MySpace Add MySQL+Data+Types+%2D+Most+Frequently+Used to Del.icio.us Digg MySQL+Data+Types+%2D+Most+Frequently+Used Add MySQL+Data+Types+%2D+Most+Frequently+Used to Yahoo My Web Add MySQL+Data+Types+%2D+Most+Frequently+Used to Google Bookmarks Add MySQL+Data+Types+%2D+Most+Frequently+Used to Stumbleupon Add MySQL+Data+Types+%2D+Most+Frequently+Used to Reddit




RSS | Editor's Picks Articles | Top Ten Articles | Previous Features | Site Map


For FREE email updates, subscribe to the PHP Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 by Diane Cipollo. All rights reserved.
This content was written by Diane Cipollo. If you wish to use this content in any manner, you need written permission. Contact BellaOnline Administration for details.

g


g features
Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor