DELETE * FROM Table1;
DELETE * FROM Table2;

##</code><code>##

INSERT INTO Table1 (Folder) VALUES ('myfolder1');
INSERT INTO Table2 (Account, Type, Folder) VALUES ('Account1', 'type1', 'myfolder1');

##</code><code>##

UPDATE Table2 SET Table2.Folder_ID = Table1.Folder_ID WHERE Table1.Folder = Table2.Folder;