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

 

[supercrewd]

okay, thanks a lot will give it a try