Can I Store a Single Variable (not in a Table) In PHP/MySQL Database

Question

I have a database which stores a large amount of data in tables. This works fine, but I have a few individual variables that I need to store which are not "repeatable" in the sense that there will be no need for additional rows to store more copies of them.

I could just create a single table storing these miscellaneous variables and leave only a single row in that table, but that doesn't seem like the most efficient or cleanest option.

Is there a better approach (or ideally a way to store a single variable in MySQL)?

rawdog · Accepted Answer · 2013-12-15 11:41:34Z

12

Just create a table e.g. called 'variables' with two fields 'name' and 'value'. Store your variables in this table, and there you go.

answered Dec 15, 2013 at 11:41

rawdog

7309 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Michael.Lumley Over a year ago

Good idea. I should have thought of that. Thanks.

Collectives™ on Stack Overflow

Can I Store a Single Variable (not in a Table) In PHP/MySQL Database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related