MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tablename (
  `id` INTEGER PRIMARY KEY AUTO_INCREMENT,
  `col1` VARCHAR(5),
  `col2` VARCHAR(6)
);
INSERT INTO tablename (col1, col2) VALUES ('Test1', 'VALUE1');
INSERT INTO tablename(col1, col2) 
SELECT col1, 'VALUE2' 
FROM tablename 
WHERE id = 1

Records: 1  Duplicates: 0  Warnings: 0


SELECT * FROM tablename;


id
col1
col2


1
Test1
VALUE1

2
Test1
VALUE2