Mysql – phpmyadmin
What’s wrong with this query?
ALTER TABLE `invoices`
CHANGE `status` `status` ENUM('paid','due','canceled','partial','cheque')
CHARACTER SET `utf8` COLLATE `utf8_general_ci` NOT NULL DEFAULT `due`;
I am getting this error:
Missing comma before start of a new alter operation. (near "CHARACTER SET") and not able to run this query on live server. Query was generated when I changed the table structure on my localhost during development.
I also tried below query mentioned in many threads but it also give same above error:
ALTER TABLE `invoices` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
2
Answers
Am not sure why. I also faced the same issue.
Though it appears like:
i.e
Before
After
REFERENCE:
https://github.com/phpmyadmin/sql-parser/issues/229
Good luck!