re: ALTER a auto_increment column

On Tuesday 17 December 2002 03:09, Lopez David E-r9374c wrote: > Problem is type SMALLINT needs to be MEDIUMINT (MyISAM). > > column: id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT > > My solution is to use the following ALTER statement: > > ALTER TABLE messages CHANGE id > id MEDIUMINT UNSI

ALTER a auto_increment column

Guru's Problem is type SMALLINT needs to be MEDIUMINT (MyISAM). column: id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT My solution is to use the following ALTER statement: ALTER TABLE messages CHANGE id id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT My question is: what happens to the s