simondiercks on 03/30/10
Last Edited at 03/30/10 06:16am
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);
Report this snippet Tweet
Comment:
You need to login to post a comment.