Welcome Guest ( Log In | Register)



 
Reply to this topicStart new topic
> Can Database Column Names Start With A Number?, Can database column names start with a number?
eskimmer
post Aug 16 2007, 01:43 PM
Post #1


Newbie [Level 1]
*

Group: Members
Posts: 21
Joined: 15-August 07
Member No.: 48,203



Can database column names start with a number or must they start with a letter like php vars? Like my_table.1fieldname ?

Does this vary from db system to db system? Is it considered good/bad form?
Go to the top of the page
 
+Quote Post
Plenoptic
post Aug 16 2007, 03:02 PM
Post #2


Trap Double Mocha Member
***************

Group: [HOSTED]
Posts: 2,220
Joined: 5-November 05
From: That one place over there...
Member No.: 13,830



It'd probably be better to put the number at the end like fieldname1 instead of putting the number at the beginning. I don't know if it will even let you put the number at the beginning but it's probably easier to put it at the end plus when you go to say it you generally would put it at the end.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Chatbox / Guestbook(2)
  2. Mysql Edit(4)
  3. Writing To Database Problem With Mysql - Not Writing Forum Post(3)
  4. Help Importing Mysql Database Results(3)
  5. Personal Blog(4)
  6. Script That Deletes A Row In A Mysql Database Usin(1)
  7. Database Extraction Layer(1)
  8. Is Doing The Whole Database / Php Thing Worth It?(13)
  9. Can You Add Images Into A Mysql Database?(20)
  10. Login / Authetication System Using Database(4)
  11. Crontab Automated Database Backup(2)
  12. Showing Numbers Of Mysql Entries In A Database Table(7)
  13. Code To Install Mysql Database Table?(5)
  14. File In Database(1)
  15. Problem To Join Tables In Database(3)
  1. Php Search Engine Script For Mysql Database(11)
  2. Importing .csv Into Mysql Database(6)
  3. Editing Information In A Mysql Database And Deleting Rows(5)
  4. Download Database Backup(0)
  5. Read Xml And Import Into Database(2)
  6. Auto Pruning An Sql Database With Php(4)
  7. Connecting Php Site To Database(6)
  8. How Do I Connect To Live Database With Php Script?(6)
  9. Ms-access Database Question(3)


 



- Lo-Fi Version Time is now: 26th July 2008 - 07:10 AM