I have 2 tables "Source" and "Destination" that have the same fields, except for the destination having an extra 'date' field
I need to copy the all the fields to their corresponding fields in destination leaving date blank.
I tried:
INSERT INTO Destination SELECT * FROM Source
got :
[SQLITE_ERROR] SQL error or missing database (table destination has 18 columns but 17 values were supplied).
How can I make this work?