Page 1 of 1

MySQL Database setup

Posted: Sat Nov 03, 2007 6:08 pm
by lyleyboy
Hi,

I've been wondering...

If I set up a table with an ID auto-incremented field but only set that field to a tinyint (for example) what happens when data keeps being added and the ranges gets to 255?

Will the program fail?

Thanks

Posted: Sat Nov 03, 2007 6:20 pm
by feyd
The program will.... test it.

Hmm

Posted: Sat Nov 03, 2007 6:22 pm
by lyleyboy
So what do you suggest I set my ID fields to?

What do you use?

Trying to keep things small for speed but good enough to last.

Thanks

Posted: Sat Nov 03, 2007 7:52 pm
by feyd
INT if not BIGINT (unsigned) at full bandwidth.