While adding auto increment value to one of the columns in my mysql database table, I got the error saying:
ALTER TABLE `tablename` ADD `id` VARCHAR(11) NOT NULL AUTO_INCREMENT AFTER `userid`, ADD PRIMARY KEY (`id`) ;
#1063 - Incorrect column specifier for column 'id'
The error can easily be solved by changing the “type” of the column to INT (instead of VARCHAR which you’ve probably done).
Hopefully this solves your mysql error :) Happy coding!