· 8 years ago · Jan 19, 2018, 01:36 AM
1CREATE TEMPORARY TABLE IF NOT EXISTS temp LIKE licences; 2INSERT INTO temp SELECT * FROM licences; 3TRUNCATE TABLE licences; 4INSERT INTO licences SELECT * FROM temp; 5DROP TEMPORARY TABLE temp;