Home -> Usenet -> comp.databases.theory -> Database column names.

Database column names.

From: Lee Osborne <osbornelee_at_hotmail.com>
Date: Thu, 10 May 2001 09:37:51 +0100
Message-ID: <989483933.7511.0.nnrp-14.c2de1f0e_at_news.demon.co.uk> 






Hi all,



I am using MySQL for web database backends. This invariable involves pulling
the data from the tables and displaying on web browser forms and such like.



I know that I can't use spaces in my column names. What is the standard way
of naming colums bearing in mind the conversion on the name to a displayable
format in the web browser eg.



NAMING CONVENTION 1.






SQL column:



   . your_full_name





On-screen display:



   . Your full name





HTML:


    . Your full name: <input name="your_full_name" value="$your_full_name">





NAMING CONVENTION 2






SQL column:



   . yourFullName





On-screen display:



    . Your Full Name



HTML:




   . Your full name: <input name="yourFullName" value="$yourFullName">






I personally prefer the second convention for readability and efficiency.
Converting either convention to on-screen display is very each.



I want to make my programs as portable and platform independant as possible.



Any thoughts?



Thanks,



Lee.
Received on Thu May 10 2001 - 10:37:51 CEST












Original text of this message