Tuesday, May 13, 2025

mysql move data over year

 CREATE TABLE record_packing_ok_2024 LIKE record_packing_ok;


INSERT INTO record_packing_ok_2024

SELECT *

FROM record_packing_ok

WHERE YEAR(date_time) < 2025;


DELETE FROM `record_packing_ok` WHERE year(`date_time`)<2025;