What's the correct way to store a list in MySQL?

Question

I'm trying to make a list of numbers structure in MySQL (phpMyAdmin), I was thinking about storing it as a varchar with commas between all the numbers, and then when I want to fetch them I just split them, but I'm not sure if this is the best way to do it.

~Sorry if I wasn't clear, my English isn't that good.

score 1 · Accepted Answer · answered Jul 15 '15 at 15:55

1

Depending on the length of the number, probably you can use just use TEXT data type.

answered Jul 15 '15 at 15:55

HashSu

1,507
1
13
13

So, TEXT data type can store more characters? – PepsiGam3r Jul 15 '15 at 16:01
Yes. BLOB, TEXT L + 2 bytes, where L < 2 power 16 – HashSu Jul 15 '15 at 16:03
Maybe you should use VARCHAR instead of TEXT/BLOB because of how values are stored as explained here - http://stackoverflow.com/questions/2023481/mysql-large-varchar-vs-text – Ondřej Šotek Jul 15 '15 at 16:54

score 0 · Answer 2 · answered Jul 15 '15 at 16:02

0

with explode function you can separate your data with specified character and store into array

ex.

$demo = '1,2,3,4';
$data = explode(',',$demo);

this with store 1,2,3,4 separately in data array

answered Jul 15 '15 at 16:02

Divyank

740
3
20

I get it, so I store the data as TEXT and then just explode it. – PepsiGam3r Jul 15 '15 at 16:04
yea, saving data as varchar or text doesn't matter – Divyank Jul 15 '15 at 16:08

What's the correct way to store a list in MySQL?

2 Answers2