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
Post a Comment