Easy way to add records from one MySQL table to another?

Trying to avoid select/insert for each record

[MichaelBluejay]

Every night I want to add the records from my <daily> table to my <longterm> table. Seems like there ought to be an easy way to do this. I'm trying to avoid what seems inefficient, in Perl:

$cursor = $DB->prepare("SELECT * FROM daily); 
$cursor->execute; 
while @data = ($cursor->fetchrow) { 
 $DB->do("INSERT into longterm values('$data[0]','$data[1]','$data[3]','$data[4]','$data[5]')"); 
} 

Is there some simple MySQL command that does something like "add the records from table A to table B"?

[marcmesa]

i'm a semi-nice into mysql but i think that a better way to do it is without having to make an insert for every row. Instead use one multiple-insert.

/*SQL query*/
INSERT INTO longterm
SELECT *
FROM daily

Execute the query the perl way (sorry, i don't know perl)

Hope it helps!

[MichaelBluejay]

Wow, that's great. With Perl all I have to do is:

$DB->do("INSERT into longterm SELECT * FROM daily");

This is exactly what I needed. Thanks!

[marcmesa]

Glad to help you.

NOTE: in the other post it says semi-nice whre i would say semi-novice (newbie)

[coopster]

Well then I'd have to say you were a very-nice semi-novice, marcmesa.
Welcome to WebmasterWorld ;)