I have two tables with identical structure except for one column... Table 2 has that additional column in which i would insert the CURRENT_DATE()
I would like to copy all the values from table1 to table2.
if i use
INSERT INTO dues_storage SELECT * FROM dues WHERE id=5;
To refine the answer from Zed, and to answer your comment:
INSERT INTO dues_storage SELECT d.*, CURRENT_DATE() FROM dues d WHERE id = 5;
See T.J. Crowder's comment