27.05.2017, 14:04
Quote:
I'm confused by your terminology.
Generally if you need to add a number to a column name then you're doing it wrong. In such cases it is almost always advised to create another table. In database design you need to think ahead. Ask yourself questions like "what if I need to store 100,000 of these things?". Then you'll usually come to the conclusion that "no, I can't add 100,000 columns". If I table exceeds 20 columns I already feel uncomfortable. |
I should create a table for each variable I would like to store?