Are you creating new tables or importing from an old application? If you are building something from scratch it is a really really bad idea to use spaces in the names or start putting in special characters, you're just making more work for yourself, and anyone that works on the application after you is going to want to strangle you :)
Using an uppercase letter to signify a new word seems to be a pretty consistently used convention, so employeeInformation or departmentEmployeeXref would be common (I like upper cases on the first letter too, but that seems to not be as common). If you are importing an old application into MySQL and need to use '-', you must escape it with `. -----Original Message----- From: Octavian Rasnita [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 6:41 AM To: MySQL Subject: Column names Hi all, In MySQL I know that I need to put the column names between `` in some cases if they contain a % or an _ sign in it. Please tell me what sign can I use to link 2 words in a column without needing to include that column name between ``. Can I use a - (dash) sign, or it might be considered in some cases a minus operator? Thank you for any idea. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php