jerrittpace wrote:To be honest, I am going to go ahead and just delete and reenter the table, but I would like to know what can be done to be able to amend this in the future.
jerrittpace wrote:Yeah I know, I need a primary key, but phpMyadmin will not let me change the ID entry, the first entry, to a primary key, because it already has values entered as '0', which are duplicate values that a primary key cannot hold. Then, it will not let me delete values because there is no primary key defined.
ALTER TABLE `tablename` ADD `pk` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
Users browsing this forum: No registered users and 64 guests