int datatype

[atse]

Hi,

In mySQL, I found the date type has smallint, int and bigint. What are their
differences? I set a field with auto_increment as int type, what will happen
when the number reaches to the limit? Thanks for any help.

Atse

[Aggro]

atse wrote:

In mySQL, I found the date type has smallint, int and bigint. What are their
http://www.mysql.com/doc/en/Numeric_types.html
differences? I set a field with auto_increment as int type, what will happen
when the number reaches to the limit? Thanks for any help.

It will give you an sql error if you try to insert row while it can't
put it there. You should always use types that are large enough. Also,
use int unsigned if you are using auto_increment, because you don't need
negative values and it will give you twice as much positive numbers.

[Aggro]

atse wrote:

In mySQL, I found the date type has smallint, int and bigint. What are their
http://www.mysql.com/doc/en/Numeric_types.html
differences? I set a field with auto_increment as int type, what will happen
when the number reaches to the limit? Thanks for any help.

It will give you an sql error if you try to insert row while it can't
put it there. You should always use types that are large enough. Also,
use int unsigned if you are using auto_increment, because you don't need
negative values and it will give you twice as much positive numbers.

[atse]

Got it, thanks.

"Aggro" <sp**********@yahoo.com> wrote in message
news:uH***************@read3.inet.fi...

atse wrote:

In mySQL, I found the date type has smallint, int and bigint. What are their

http://www.mysql.com/doc/en/Numeric_types.html

differences? I set a field with auto_increment as int type, what will

happen when the number reaches to the limit? Thanks for any help.

It will give you an sql error if you try to insert row while it can't
put it there. You should always use types that are large enough. Also,
use int unsigned if you are using auto_increment, because you don't need
negative values and it will give you twice as much positive numbers.

[atse]

Got it, thanks.

"Aggro" <sp**********@yahoo.com> wrote in message
news:uH***************@read3.inet.fi...

atse wrote:

In mySQL, I found the date type has smallint, int and bigint. What are their

http://www.mysql.com/doc/en/Numeric_types.html

differences? I set a field with auto_increment as int type, what will

happen when the number reaches to the limit? Thanks for any help.

It will give you an sql error if you try to insert row while it can't
put it there. You should always use types that are large enough. Also,
use int unsigned if you are using auto_increment, because you don't need
negative values and it will give you twice as much positive numbers.