Cant rename a column in MySQL

Asked Apr 08 '21 at 13:53

Active Apr 08 '21 at 13:57

Viewed 31 times

I've tried to rename a column from row which is int in my db to row_number. The name of my table is screening_occapancy. I tried this:

ALTER TABLE screening_occapancy CHANGE COLUMN row to row_number;

The error is: Error Code: 1064. 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 'row to row_number' at line 1.

edited Apr 08 '21 at 13:57

WOUNDEDStevenJones

5,150
6
41
53

asked Apr 08 '21 at 13:53

danielgil82

You need to provide the full column definition. It's not possible to just change the name. – Álvaro González Apr 08 '21 at 13:56
1

Both `row` and `row_number` are reserved words. – Akina Apr 08 '21 at 13:57
That's the point i've got an assignment from college and my db contains this table with a column named row (which is the full name of the column) how do I overcome this problem? – danielgil82 Apr 08 '21 at 19:37

Cant rename a column in MySQL

0 Answers0