Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
lyleyboy
Forum Commoner
Posts: 27 Joined: Sat Mar 18, 2006 5:05 am
Location: Birmingham, UK
Post
by lyleyboy » Sat Nov 03, 2007 6:08 pm
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
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Sat Nov 03, 2007 6:20 pm
The program will.... test it.
lyleyboy
Forum Commoner
Posts: 27 Joined: Sat Mar 18, 2006 5:05 am
Location: Birmingham, UK
Post
by lyleyboy » Sat Nov 03, 2007 6:22 pm
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
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Sat Nov 03, 2007 7:52 pm
INT if not BIGINT (unsigned) at full bandwidth.