I've been having this debate in my mind and alternated my method on the
past few projects I've worked on, and now I ask you, the MySQL community.
What is the best way to have a preferences table?
Here's what I've been doing:
Table preferences
basepath varchar(255)
adminemail varchar(255)
and
That seems to follow how I've been doing it as well.
For example, consider this database set up:
Table: news
Fields:
newsid int(10)
userid int(10)
dateposted datetime
subject varchar(255)
content text
Table: users
Fields:
userid int(10)
name varchar(60)
and on and on. I'd love to hear from som
Howdy,
I've been developing in MySQL for some time now, but as I go along I've
noticed that my naming conventions have changed dramatically, and I was
wondering if there is like a set of guidelines or something I could take
a look at. A set of standards, if you will, for naming conventions of
