mysql input line too long and other
#5

Just going to copy my reply from 5 minutes ago in another thread;

Quote:
Originally Posted by Vince
Посмотреть сообщение
1) Use default values. This will significantly shorten your query because you don't have to insert zeros.
2) Inventory information should actually be moved to a separate table. If there can be an indefinite amount of something it should be in a separate table. Now you can argue that you only want to store three weapons, but if in the future you decide you want to store more you have to edit your database and your queries, whereas with proper normalization you wouldn't have to change anything.
Time for another tutorial on normalization, I guess.
Reply


Messages In This Thread
mysql input line too long and other - by ilepopivanov - 10.01.2015, 09:58
Re: mysql input line too long and other - by Sascha - 10.01.2015, 10:26
Re: mysql input line too long and other - by bgedition - 10.01.2015, 10:59
Re: mysql input line too long and other - by Pottus - 10.01.2015, 11:02
Re: mysql input line too long and other - by Vince - 10.01.2015, 12:53

Forum Jump:


Users browsing this thread: 1 Guest(s)