INSERT INTO
table
(col1
, col2
, col3
, col4
) SELECT col1
, col2
, col3
, col4
FROM table
WHERE id
=1;
id
can be anything unique.
INSERT INTO
table
(col1
, col2
, col3
, col4
) SELECT col1
, col2
, col3
, col4
FROM table
WHERE id
=1;
id
can be anything unique.