The INSERT SELECT statement adds a new row to the table based on a SELECT statement:

INSERT INTO games(yr,city) SELECT yr+12, city FROM games; SELECT * FROM games;
DROP TABLE games; CREATE TABLE games(yr INT, city VARCHAR(20)); INSERT INTO games(city,yr) VALUES ('Sydney',2000); INSERT INTO games(city,yr) VALUES ('Athens',2004); INSERT INTO games(city,yr) VALUES ('Beijing',2008);

INSERT INTO games(yr,city)
  SELECT yr+12, city FROM games;
SELECT * FROM games;