Re: naming conventions

It doesn't really matter as far as I know except you cannot have a space, and its not common practice to use numbers with table names. The only thing that really matters as far as I'm concerned is that I remember how I've named it be it firstname or first_name or FirstName as long as you know then it doesn't really matter I am interested in how to best name fields in mysql - and any issues that may arise. For example look at these field names: "First Name" - is there any problem with the space? "firstname", "first_name" or "FirstName" - is there a preference here? In short I want to know if more than personal preference is involved in naming fields... Regards, Matthew Delmarter Web Developer AdplusOnline.com Ltd www.adplusonline.com Phone: 06 8357684 Cell: 025 2303630 -- Peter Houchin Sun Rentals STR Manager Phone: 03 9329 1455 Fax: 03 9329 6755 peterh@sunrentals.com.au http://www.sun.com.au/rentals ========================================================= _____ __ /\ /_/_/_\ / |_/ \ /_/_/_ __ __ __ __ / \ \_/_/_\ /_/ /_/ /_/ /_/ \ _ / ___\_\_\/ /_/_/_/ /_//\/_/ \_/ \/\_/ \_//_/_/ /_/_/_/ /_/ \/_/ v ________ ________________________________________ /_/_/_/_/ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ /_/_ _/_/ ______ __ __ /_/ ____ __ ______ /_/_/_/_/ /_/_/_/ /_/ /_/ /_/ /_/\_\ /_/ /_/_/_/ /_/ \_\ /_/ _/ /_//\/_/ /_/ /_/__\_\ /_/___ _\_\_\ /_/ \_\/_/_/_/ /_/ \/_/ /_/ /_/ \_\/_/_/_//_/_/_/ ========================================================= Telephone : (03) 9329 1455 Facsimile : (03) 9329 6755 ************* We rent the dot in .COM! **************