i'm trying to alter a table's column name but i keep getting an error.
alter table GelderlandDist change inauguration 'inauguration date';
but i keep getting an error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ''inau
guration date'' at line 1
My problem is I'm trying to include a space in the column name and I know I can do it because my third column is called "country code" with a space in between, but I'm not sure how to alter the table to change it