Topic: 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.