Jump to content


Photo

table names


  • Please log in to reply
3 replies to this topic

#1 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 September 2006 - 08:41 PM

I have noticed that i end up using table names with spaces
Terms Of Service
or whatever, is this right, i remember something about them not suppose to have spaces, and I never see anyone else with spaces, but they still work fine???

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 25 September 2006 - 08:47 PM

If you use backticks, you can name them whatever you please -- but it's a bad idea, so don't.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 September 2006 - 10:05 PM

ok, so from now on, I will name them without spaces, thanks.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#4 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 25 September 2006 - 11:11 PM

... and don't use reserved words for table or field names either ... just in case you're tempted. And stay away from symbols too.  If you really want rational names, you can always replace the space with an underscore.
Legend has it that reading the manual never killed anyone.
My site




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users