Rifts Posted March 15, 2010 Share Posted March 15, 2010 really simple can I use a number such as 001 as a column name becuase if so i can not figure out the syntax for it im trying alter table members add column 001 varchar (3) and i tried alter table members add column '001' varchar (3) Quote Link to comment https://forums.phpfreaks.com/topic/195353-random-question-google-didnt-help/ Share on other sites More sharing options...
MatthewJ Posted March 15, 2010 Share Posted March 15, 2010 From the mysql documentation Identifiers may begin with a digit but unless quoted may not consist solely of digits Hope that helps. Quote Link to comment https://forums.phpfreaks.com/topic/195353-random-question-google-didnt-help/#findComment-1026576 Share on other sites More sharing options...
wildteen88 Posted March 15, 2010 Share Posted March 15, 2010 Both of those are correct except 001 should be wrapped in backticks eg `001`. Quote Link to comment https://forums.phpfreaks.com/topic/195353-random-question-google-didnt-help/#findComment-1026581 Share on other sites More sharing options...
fenway Posted March 19, 2010 Share Posted March 19, 2010 Please don't. Quote Link to comment https://forums.phpfreaks.com/topic/195353-random-question-google-didnt-help/#findComment-1028547 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.