While adding auto increment value to one of the columns in my mysql database table, I got the error saying:

Error

SQL query:

ALTER TABLE `tablename`  ADD `id` VARCHAR(11) NOT NULL AUTO_INCREMENT  AFTER `userid`,  ADD   PRIMARY KEY  (`id`) ;

MySQL said: 

#1063 - Incorrect column specifier for column 'id' 

Solution

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!

You might also like

• Forward POST variables to another php page using curl (1)
• How to use .htaccess on IIS (mod_rewrite for microsoft iis server) (1)
• Detect users internet browser (firefox, safari, iphone, ipod, ipad, internet explorer, opera ) and redirect to different page specific to it (1)