 |
Guardians of Grail
The best PVKII Clan
|
| View previous topic :: View next topic |
| Author |
Message |
cheapbag214s
Post Master
Joined: 27 Jun 2013
Posts: 19871
Read: 0 topics
Warns: 0/5
Location: England
|
 Posted: Mon 0:58, 19 Aug 2013 Post subject: how do I SUM column values if the name of the colu |
|
|
how do I SUM column values if the name of the column contains a word,[link widoczny dla zalogowanych]
The maximum number of columns in a table is 1024 so you can't keep adding columns for every brand/item permutation that ever occurs,[link widoczny dla zalogowanych].
If a brand makes bags and shoes you will be repeating the information about the brand multiple times,[link widoczny dla zalogowanych]. Any time such information is repeated there is a possibility that slight differences and anomalies creep in,[link widoczny dla zalogowanych]. Additionally if a brand changes their name you need to update the column and all code you have that references it,[link widoczny dla zalogowanych].
You can't do simple calculations such as summing all bags without hard-coding all the permutations and remembering to update that code when you add a new brand,[link widoczny dla zalogowanych].
You can't do some queries at all (or at least not without great difficulty) - such as bring back the name of all brands that supply shoes,[link widoczny dla zalogowanych].
Well,[link widoczny dla zalogowanych], I wanted to try to solve this as asked as an exercise for myself because I'm learning SQL in more depth. I think the problems with the given schema are well-enough documented for me to not say anything else about that.相关的主题文章：
http://www.philosophiaupjp2.fora.pl/dla-kandydatow,47/a-canadian-reaches-biathlon-word-cup-podium-for-fi,2356.html#2530
http://www.vasotecdzeen.fora.pl/need-you-two-brown-the-hole-prozac-news-positions,1/they-might-be-giants-nike-blazer-ijbu,2811.html#2831
[link widoczny dla zalogowanych]
http://www.ephedraonline.fora.pl/forum-testowe,1/any-know-if-nike-sneakers-run-true-to-size-nike-bl,3764.html#3802
http://www.hardpartyprodss.fora.pl/hard-party-production,3/donning-evaluate-the-nickelodeon-people-choice-pri,2390.html#2420
http://www.loltestab.fora.pl/forum-testowe,1/terror-suspect-in-stormy-court-hearing-nike-blazer,2216.html#2234
[link widoczny dla zalogowanych]
[link widoczny dla zalogowanych]
http://www.enutka.fora.pl/rock-metal,8/gunstock-checkering-tools-nike-blazer-oqxu,2219.html#3685
http://www.ragaming.fora.pl/swb-general,45/kate-moss-adore-his-isabel-marant-jacket-nike-blaz,7459.html#7715
http://www.compazinegtccv.fora.pl/what-say-watery-smile-work-during-quiet-breath-ambien-strengths-loove-you-iscouraged,1/isabel-marant-sneakers-nike-blazer-rhzs,3373.html#3399
http://www.nextovercharge.fora.pl/mods-currently-on-the-server,22/maxi-skirt-a-summer-classic-nike-blazer-eszc,3388.html#3564
http://www.nortriptylinepztbm.fora.pl/jason-clutched-featuring-brand-hand-coming-you-seduced-shoulders-tightened-politics,1/jake-and-the-neverland-pirates-clothes-are-so-cool,2278.html#2280
http://www.nifedipinerbzzp.fora.pl/most-often-metformin-hci-1000-mg-augmentin-generic-equipment,1/1003-madison-ave-new-york-spun1-nike-blazer-pqvf,11866.html#12134
http://www.xanaxnoprescription.fora.pl/forum-testowe,1/boy-would-wear-high-heel-shoes-to-school-spun2-nik,2545.html#2571
The post has been approved 0 times
|
|
| Back to top |
|
 |
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
fora.pl - załóż własne forum dyskusyjne za darmo
Powered by phpBB © 2001, 2005 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Galleries
Register
Log in to check your private messages
Log in
