Skip to Main Content
Sams Teach Yourself MySQL in 21 Days, Second Edition
book

Sams Teach Yourself MySQL in 21 Days, Second Edition

by Tony Butcher
December 2002
Beginner content levelBeginner
640 pages
16h 41m
English
Sams
Content preview from Sams Teach Yourself MySQL in 21 Days, Second Edition

Numeric Column Types

MySQL can represent both integers (numbers with no fractional part) and floating-point numbers (those with a fractional part).

Table 5.1 shows the numeric column types.

Table 5.1. Numeric Display Formats
Type NameRangeStorage Required
TINYINTsigned: -128 to 127 
 unsigned: 0 to 2551 byte
SMALLINTsigned: -32768 to 32767 
 unsigned: 0 to 655352 bytes
MEDIUMINTsigned: -8388604 to 8388607 
 unsigned: 0 to 167772153 bytes
INTsigned: -2147483648 to 2147483647 (-231 to 231-1) 
 unsigned: 0 to 4294967295 (0 to 232-1)4 bytes
BIGINTsigned: -263 to 263-1 
 unsigned: 0 to 264-18 bytes
FLOATminimum non-zero: ±1.175494351E-38 
 maximum: ±3.402823466E+384 bytes
DOUBLEminimum non-zero: ±2.2250738585072014E-308 
 maximum: ±1.7976931348623157E+3088 bytes ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Sams Teach Yourself MySQL

Sams Teach Yourself MySQL

Chris Newman
Oracle® Database 10g Insider Solutions

Oracle® Database 10g Insider Solutions

Arun Kumar R., John Kanagaraj, Richard Stroupe
MySQL and mSQL

MySQL and mSQL

Tim King, George Reese, Randy Yarger
Jump Start MySQL

Jump Start MySQL

Timothy Boronczyk

Publisher Resources

ISBN: 0672323923Purchase book