random question google didnt help

[Rifts]

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)

[MatthewJ]

From the mysql documentation

 

Identifiers may begin with a digit but unless quoted may not consist solely of digits

 

Hope that helps.

[wildteen88]

Both of those are correct except 001 should be wrapped in backticks  eg `001`.

[fenway]

Please don't.