Posted By

simondiercks on 03/30/10

Tagged

mysql
table

Versions (?)

Last Edited at 03/30/10 06:16am

Statistics

Viewed 1058 times

Favorited by 0 user(s)

Related snippets

add auto-imcremented column to existing table without ex- and reimporting

/ Published in: MySQL

How to add an auto-incremented column to an existing table without ex- and reimporting.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

alter table t1, change id id int (11) DEFAULT '0' NOT NULL, drop primary key;
ALTER TABLE table ADD id2 INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (id2);
alter table t1, change id2 id2 int (10)  NULL, drop primary key;
alter table t1, change id id int (11)UNSIGNED  DEFAULT '0' NOT NULL AUTO_INCREMENT, add primary key(id);