How does MySQL save data?

Question

MySQL

The question is how MySQL takes up disk space, and the correct choice of data type.
For example, let's assume that there are a million articles that have a title and a description.

title: VARCHAR(250)
content: TEXT

From these articles:

• 30% have text less than 1000 characters
  
• 30% over 1000 and under 5000
  
• the rest are over 5000
  

If you make 3 tables, and in each specify content equal to the desired length, MySQL will take up less disk space?
So MySQL reserves the "maximum" space for each row? Or does it take up space only for the data that it currently has?

Answer 1

If you make 3 tables of the same type instead of one, you can one day end up in a fool. It's not worth the risk. The TEXT
data types were invented to save us.