INSERT INTO neue_tabelle(feld0, feld1, ...) SELECT feld0, feld1, ... FROM alte_tabelle WHERE bedingung ...;

INSERT INTO neue_tabelle(feld0, feld1, ...) SELECT DISTINCT feld0, feld1, ... FROM alte_tabelle WHERE bedingung ...;

  
#SQL-Abfrage -500=5Minuten; -50000=5Stunden JJJJMMDDHHMMSS

$sth =$dbh->prepare ("
           SELECT  *
           FROM Daten
          WHERE time BETWEEN sysdate()-500000 AND sysdate()-0
           ");

$sth->execute ();

while
 ( @zeile =$sth->fetchrow_array ())
    {
      printf br
        ("ID = %s, time = %s, gerät = %s, beschreibung = %s, text = %s, index =%s, test = %s" ),
            $id=$zeile[0],
            $time=$zeile[1],
            $geraet=$zeile[2],
            $beschreibung=$zeile[3],
            $text=$zeile[4],
            $index= $zeile[5],
            $test=$zeile[6],
    };

 $dbh1->do
 (qq
    {ID, time, gerät , beschreibung , text, index , test ")
     VALUES(?,?,?,?,?,?,?)
    },
      undef,
            $id,
            $time,
            $geraet,
            $beschreibung,
            $text,
            $index,
            $test,

);

 $dbh1->do
(qq{INSERT INTO tabellenname (ID, time, gerät , beschreibung , text, index , test)
    VALUES(?,?,?,?,?,?,?)
   },
     undef,@zeile);