Making a field autoincrement – mysql

ALTER TABLE `monitor` CHANGE  `indexa` `indexa` INT(10)AUTO_INCREMENT PRIMARY KEY;

indexa is the field being changed.


You are reading this post on Joel G Mathew’s tech blog. Joel's personal blog is the Eyrie, hosted here.