CSV storage InnoDB?
| From: | Karl DeSaulniers | Date: | Tue, 27 Nov 2012 00:43:46 +0000 |
| Subject: | CSV storage InnoDB? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48578@lists.php.net to get a copy of this message | ||
Hello all,
Quick question.
What is the best way to store a comma separated list of discount codes in a InnoDB?
Text, varchar, blob, ? I want to be able to store discount codes offered to users in their profile, in their cart, etc.
So I am thinking of storing the codes as a comma separated list that I can then refer to, add to or remove codes from.
The codes will change every once and a while and they list of codes may be rather large after say a year,
so I am shying away from an enum() or anything like that.
Any help/pointers is greatly appreciated.
Best,
Karl