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
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
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
