My own workaround using inserting the result of SELECT.
INSERT INTO test (`id`, `other`, `column`, `names`)
SELECT '2' as `id`, `other`, `column`, `names`
FROM test
WHERE test.id = '1';
Delete previous records using,
ALTER TABLE `test`
DELETE WHERE `id` = '2';