Copy row from one MySQL DB to another -

how it's possible copy 1 entry row of table same data (same id, same data values) database -> same table?

example:

table units: uid department name       item  67    hr       john doe   table

if both tables equal no. of columns , in same order want insert use below simple query-

insert mytable select * units uid=67;

if want insert selected column in table's selected columns , in order use below-

insert mytable(col1,col2,col3,col4) select uid,department,`name`,item units uid=67;

JAV