MYSQL collection

(1) Insert rows from select result set

13.2.5.1. INSERT ... SELECT Syntax

INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE]
    [INTO] tbl_name [(col_name,...)]
    SELECT ...
    [ ON DUPLICATE KEY UPDATE col_name=expr, ... ]

eg. Tie_all have the same structure as Tie2. Tie_all:(id,reviewer1,reviewer2,tie_strength)

insert into Tie_all (reviewer1,reviewer2,tie_strength) (select reviewer1,reviewer2,tie_strength from Tie2);