INSERT INTO status_meldung_2016 SELECT * FROM `status_meldung` WHERE `datum` < '2017-01-01'; DELETE FROM `status_meldung` WHERE `datum` < '2017-01-01'