Store each news in a table or a table for all news?

Asked

Viewed 23 times

0

I’m setting up a news site. For a faster and more efficient database it is more correct that I create a table to store all news or create a table for each news?

In case you create a table for each news would be done dynamically with php.

  • I believe that a table with various news....

1 answer

1

The correct thing is to create a table where all the news will be. Each row of this table will be different news and each column represents a news property (text, date, author, or anything else you need to save). Maybe you need other tables to save authors, photos, etc... will depend on what your application needs.

To be perfectly honest, it doesn’t make any sense to store one news item per table... No offense, it seems to me that you urgently need to review the concepts of database...

I hope I’ve helped.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.