I'm just trying to rename a column following the documentation, I tried a couple of statements but nothing yet.
Total to price:
I tried:
ALTER TABLE order RENAME COLUMN total TO price;
But didn't work.
Asked
Active
Viewed 573 times
0
-
Which MariaDB version are you using?` – jarlh Mar 16 '22 at 19:31
-
110.3.34 I just found it works with CHANGE but don't know what the RENAME is for then. – Jose Navío Mar 16 '22 at 19:38
-
https://mariadb.com/kb/en/alter-table/#rename-column – Ergest Basha Mar 16 '22 at 19:41
-
Thank you, so it's not in my version. – Jose Navío Mar 16 '22 at 19:43
-
the RENAME COLUMN syntax is a new feature of MariaDB 10.5, it is not supported by the version 10.3.34 you are working with – Thierry Gerardin Mar 16 '22 at 19:51
1 Answers
1
Try this if your are using a version below 10.5
ALTER TABLE order CHANGE COLUMN total TO price;
Andrés
- 487
- 1
- 12