MySQL: SQL insert query to duplicate data in same table

Question

I have a table say table1(id, col2, col3), and I want to duplicate all data of id 1 but with different id say 11 (id is not auto generated column). I wrote the following sql query which is not working for me (giving syntax error):

INSERT INTO table1(
id,
col2,
col3
)
VALUES (

SELECT 11 , col2, col3
FROM table1 WHERE id=1
)

Answer 1

Don't use the "VALUES" keyword

INSERT INTO table1(
id,
col2,
col3
)


SELECT 11 , col2, col3
FROM table1
WHERE id = 1

EDIT :

Check if you're working with the right column names :

DESC table1;

Answer 2

Try this:

INSERT INTO table1(
id,
col2,
col3
)
SELECT 11 , col2, col3
FROM table1
WHERE table1.id = 1

OR if you need more something like this:

INSERT INTO table1(id, col2, col3)
SELECT (SELECT MAX(id) FROM table1) + 1 , col2, col3
FROM table1