question about mysql
#3

Quote:
Originally Posted by Vince
Посмотреть сообщение
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.
so basically it's yes?
I should create a table for each variable I would like to store?
Reply


Messages In This Thread
question about mysql - by Lirbo - 27.05.2017, 12:34
Re: question about mysql - by Vince - 27.05.2017, 13:47
Re: question about mysql - by Lirbo - 27.05.2017, 14:04
Re: question about mysql - by Cadilab - 27.05.2017, 15:02
Re: question about mysql - by Lirbo - 27.05.2017, 17:41
Re: question about mysql - by [WSF]ThA_Devil - 27.05.2017, 18:01

Forum Jump:


Users browsing this thread: 1 Guest(s)