How should I structure my settings table with mysql?

Posted by incrediman on Stack Overflow See other posts from Stack Overflow or by incrediman
Published on 2010-03-18T11:44:24Z Indexed on 2010/03/18 11:51 UTC
Read the original article Hit count: 108

Filed under:
|
|

I want to use MySQL to store a bunch of admin settings - what's the best way to structure the table?

Like this?

Setting _|_ Value
setting1 |   a
setting2 |   b
setting3 |   c
setting4 |   d
setting5 |   e

Or like this?

|--------|_setting1_|_setting2_|_setting3_|_setting4_|_setting5_|
Settings |    a     |    b     |    c     |    d     |    e     |

Or maybe some other way?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about organization