>how do i copy a specific data from table1 to table2 without copying the entire table1 data to table2?
You can use SELECT SQL.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.