information regarding tables n database.....

[gurmeet]

hi friends...
i need some info about the table and database...
1. how many entries we can have in a table...? is there any limit of these entries or the size of the table?
2. is there any limit of tables in database?

3. does the data-type like(varchar, text, longtext) effects on the size of the database? wheather they r empty? means no data in these fields?

thanx in advance... plz help me , i am not fine in database management...

[Nile]

Varchar, text, and longtext are just field types. For eaxmple - if you had an article submitting system where people submitted very long articles. You'd use a longtext or a text. Varchar is for variables and chars( someone correct me if I'm wrong? ).

Take a look at this:
http://dev.mysql.com/doc/refman/5.1/en/data-types.html

[gurmeet]

ya i know about these types.... but i want to know that, if these fields are empty, means no data, even then it increase the size of the database?

[boogyman]

I do not believe there is a limit to the number of records, however if there is, it's much more then you would ever need.

It's common sense that when you insert something into the database the overall size of the database will increase. How much it increases is dependent upon the data within the record. Unfortunately that is all we can provide unless you are more specific about what you are trying to accomplish/avoid.