a few mySql questions

[_underdog]

1) Is there a maximum number of rows that you can have in a mySql table?

2) I was also unclear on when you are defining a table if you make a column "int(12)" does the "12" limit the size of the integer or does it just limit the number of charaters displayed. If it does limit it then do you need to define id columns for very large databases something like "int(255)" which is the max I believe?

3) Also does anyone know what the limit is in number and size of columns in a table?

[stuka]

1) The only practical limit to number of rows is disk space.
2) The (12) in the integer type columns is the maximum display size.
3) Again, this is more a limit of disk space than anything else (though to be fair, 500 column tables are poorly designed at best).

[TheBeansprout]

1+3) Huge tables won't do much for performance, either.