I am creating a teacher review Android Application.

As of now, I plan to create ~900 tables, each representing a professor.
Each table entry will have a field for user comments on the teacher.
Each time a user adds a comment, a new entry is added under that professor

Is this a logical way to go about this? I feel like there could be a more
efficient way of doing this. Also, will having 900 tables be too
much for MySQLite?

I was also thinking about having 1 table that will contain all the professors, and have the user comments as a field. Then, when every new comment is added I would somehow add 1 extra field. I don't think this uses databases properly, but is it possible (to +1 the number of fields)