Copying Rows in the same table (changing the unique ID while doing so) Not working!

[skhanal]

Try using single quote and different column name for concat output

INSERT INTO products (
id,
ProductName,
Tier1, Tier2, Tier3, Tier4, Tier5, Tier6, Tier7, Tier8, Tier9
) SELECT
id1 = concat(id, 'testmarker'),
ProductName,
Tier1, Tier2, Tier3, Tier4, Tier5, Tier6, Tier7, Tier8, Tier9
FROM products WHERE Tier1='Freesports'