Copy files from one table to another

[dapcigar]

I know this code works

INSERT INTO archive_table
SELECT * FROM original_table WHERE id = 1

But i want to also add the current date whenever i copy the data into a new table.

 

 

Thanks in advance

 

 

[jazzman1]

Have you tried to add now() to the selecting list of the original_table. Something like:

INSERT INTO archive_table(col_1, col_2, col_3)
SELECT col_1,col_2, now() FROM original_table WHERE id = 1

[dapcigar]

Yeah, that solved the issue... thanks