MySQL Forums
Forum List  »  MySQL Administrator

Re: How int Datatype works
Posted by: Jay Alverson
Date: April 15, 2009 10:46AM

Download the MySQL Manual for your version at:
http://dev.mysql.com/doc/#refman

(I like the CHM version)

Checkout Chapter 10.1.1. Overview of Numeric Types

from the manual...

INT[(M)] [UNSIGNED] [ZEROFILL] 

A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295. 

INTEGER[(M)] [UNSIGNED] [ZEROFILL] 

This type is a synonym for INT.

The stuff in [ ] brackets is optional so you just have to make sure the numbers
you're storing fall within the range for what you specify.

>

Thanks, Jay

Options: ReplyQuote


Subject
Written By
Posted
April 15, 2009 06:44AM
Re: How int Datatype works
April 15, 2009 10:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.