how do i add ID's to an existing mysql database?

**ssp** · 01-26-2006, 08:23 AM

How about edit?

JD · 01-26-2006, 08:30 AM

they should already have an id.....maybe i'm just misunderstanding something

**psili** · 01-26-2006, 08:35 AM

Originally posted by SPeRMiNaToR

they should already have an id.....maybe i'm just misunderstanding something

I think he's saying he has a table that already has records.
When you alter the table and add a new field, those previous records default to null - where he wants them to get a prepopulated ID from the alter table command. Or something like that.

**psili** · 01-26-2006, 09: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

**s9ann0** · 01-26-2006, 10:06 AM

google for "MySQL front" its the shit

**VideoJ** · 01-26-2006, 12:38 PM

http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

or download and install http://www.phpmyadmin.net/home_page/index.php

how do i add ID's to an existing mysql database?

how do i add ID's to an existing mysql database?

Comment

Comment

Comment

Comment

Comment

Comment