mysql create table help

[supercrewd]

Hey all.

Im in need of a little help for planning my mysql table, basically i have a table called images, which contains image_id, image_name, image_file, i need image_id to be the primary/unique key.

Whats the best way to set the datatype so that i dont have to worry bout having too many images, as i imagine there *** be 1000's of records in it over time.

Ideally the image_id will be a auto-incremental value, will setting it as int do, or will i be limited to the max number a int can hold?

Thanks
Chris

 

[5ingh]

According to this site:

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

INT (4 bytes) can hold values from -2147483648 TO 2147483647. I guess that'll be ok?

 

[matja]

Even if you use a datatype which later turns out to be too small for your requirements, a swift 'alter table' command can be used to change it without changing your data.

I'd go with an unsigned integer, primary key, not null, auto_increment.

 

[supercrewd]

okay, thanks a lot will give it a try