I dropped a column (linknum) in a table (wine) with mysql in the console
After that I wanted to make it again
ALTER TABLE wine ADD linknum INT DEFAULT '1' NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
but now I recieve an error message like this:
ERROR 1067 (42000): Invalid default value for 'linknum'
How can I solve it, and create a column called linknum again, starting with 1 and incrementing 1 ?