database schema migration

#1 (**permalink**) 02-28-2008, 05:21 AM

hey all,
I have two tables like that:
artists(id,name)
albums(id,artist_id,album_name)

and I need to transfer the data of this database to three tables that
look like this:
artists(id,name)
albums(id,name)
artists_albums(album_id,artist_id)

any idea what's the fastest query to do this?

thanx in advance

Pat

#2 (**permalink**) 02-28-2008, 05:21 AM

Patrick Aljord wrote:
> hey all,
> I have two tables like that:
> artists(id,name)
> albums(id,artist_id,album_name)
>
> and I need to transfer the data of this database to three tables that
> look like this:
> artists(id,name)
> albums(id,name)
> artists_albums(album_id,artist_id)
>
> any idea what's the fastest query to do this?

insert into artists_albums(album_id, artist_id) select id, artist_id
from albums;

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode