How To Duplicate A Row In MySQL

INSERT INTO table ( `col1`, `col2`, `col3`, `col4`, `col5`, `col6`) 
SELECT `col1`, `col2`, `col3`, `col4`, `col5`, `col6`
FROM table
WHERE RowID = 1