GoFuckYourself.com - Adult Webmaster Forum - View Single Post - how do i add ID's to an existing mysql database?

psili · 01-26-2006, 11:00 AM

This is the only solution I could readily think of.

Your original table:

"table1 ( name, value )"

make a new table with the new ID column set to auto_increment:

"table2 ( id, name, value)"

then run a select into table type query:

INSERT INTO table2 (name,value) SELECT * from table1

01-26-2006, 11:00 AM
psili Confirmed User Join Date: Apr 2003 Location: Loveland, CO Posts: 5,526	This is the only solution I could readily think of. Your original table: "table1 ( name, value )" make a new table with the new ID column set to auto_increment: "table2 ( id, name, value)" then run a select into table type query: INSERT INTO table2 (name,value) SELECT * from table1 __________________ Your post count means nothing.