MySQL: DROP a column with a question mark sign? -


i trying drop column has question mark sign:

alter table player drop is_playing?; 

result:

error 1064 (42000): have error in sql syntax; check manual corresponds mysql server version right syntax use near '?' @ line 2 

do know other ways drop it?

thanks

use backticks escape column or tables names special names or names of reserved keywords in mysql.

and use column keyword:

alter table player drop column `is_playing?`; 

Comments

Popular posts from this blog

css - Which browser returns the correct result for getBoundingClientRect of an SVG element? -

gcc - Calling fftR4() in c from assembly -

Function that returns a formatted array in VBA -