Question

Can a number be used to name a MySQL table column?

Answer 1

18

2

I have a table that has column names like 25, 50, 100, etc..

When trying to update the table I get an error, no matter how I do it

UPDATE table SET '25'='100' WHERE id = '1'

I have tried quoting and backticking every which way but without success.