Some simple questions regarding MySQL database structure
Posted: Wed Oct 16, 2002 8:55 am
Maybe one of the MySQl gurus can answer some "probably" very basic questions about MySQL that I can't seem to find answers to, probably because the answers are only available through experiance. These answers I am sure will not only be useful to me but to other newcomers to MySQL, or if anyone knows of a source to the answers of these and similar questions then please post.
Thanks
Is there any recommended limit to the number of tables a MySQL database could or should have? and does the amount of colums that these tables contain effect this?
What is the recommended number of columns not to exceed in a table? and is this effected by the number of tables or columns there are in other tables in the database?
What is the recommended maximum length of a VARCHAR entry, say for saving someones full name or address?
What is the recommended number of digits not to exceed for a auto_increment ID column? and what is the advised number to use?
Is there a limit to the amount of information a MySQL database can hold?
Thanks
Is there any recommended limit to the number of tables a MySQL database could or should have? and does the amount of colums that these tables contain effect this?
What is the recommended number of columns not to exceed in a table? and is this effected by the number of tables or columns there are in other tables in the database?
What is the recommended maximum length of a VARCHAR entry, say for saving someones full name or address?
What is the recommended number of digits not to exceed for a auto_increment ID column? and what is the advised number to use?
Is there a limit to the amount of information a MySQL database can hold?