CREATE TEMPORARY TABLE _temp
(
   playlist_id INT,
   playlist_name VARCHAR(255),
   playlist_songs TEXT,
   last_accessed TIMESTAMP,
   length INT,
   songcount SMALLINT,
   hostname varchar(255)
);

INSERT INTO _temp (playlist_id, playlist_name, playlist_songs, last_accessed, length, songcount, hostname)
   SELECT
      (SELECT playlist_id FROM music_playlists WHERE playlist_name = music_albums.album_name) AS playlist_id,
      music_albums.album_name AS playlist_name,
      GROUP_CONCAT(song_id) AS playlist_songs,
      CURDATE() AS last_accessed,
      SUM(music_songs.length),
      COUNT(music_songs.song_id) AS songcount,
      'mythtv-01' AS hostname

   FROM music_albums

   INNER JOIN music_songs
      ON music_albums.album_id = music_songs.album_id
   INNER JOIN music_artists
      ON music_songs.artist_id = music_artists.artist_id

   GROUP BY
     music_albums.album_name;

INSERT INTO music_playlists
   SELECT * FROM _temp ORDER BY playlist_name
   ON DUPLICATE KEY UPDATE playlist_id = VALUES(playlist_id);

DROP TEMPORARY TABLE _temp;

mysql -u mythtv -p mythconverg < CreateAlbums.sql