[SOLVED] Droping and Altering id column

[RIRedinPA]

I'm trying to drop my id column and then add it back to the db. This seemed to work but it generated an error (but the column was deleted)

 

ALTER TABLE AddressBook DROP COLUMN id

 

but then I wasn't able to add the id column back. I'm also not sure how to declare this as a primary key...

 

ALTER TABLE AddressBook ADD Column (id bigint not null auto_increment)

 

thanks

[RIRedinPA]

This query did not work.

 

ALTER TABLE AddressBook ADD COLUMN "test" AFTER "email"

[rhodesa]

ALTER TABLE AddressBook ADD id INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST

[RIRedinPA]

Thanks!