Awk file processing practices

The awk file processing small practice file contains three fields (sorted): Example: summary. the awk file processing small practice file contains three fields (sorted): example: news news_1 1234556 news news_1 1234557 news news_2 1234558 news news_2 1234559 sport sport_1 2234555 sport sprot_1 2234558 sport sport_2 2234556 sport sport_2 2234557 1 according to the first column, write the same data in the first column to the same file awk '{print $2, $3> $1}' file 2, and cut it into different After the file is created, the following SQL statements are constructed: (select * from news_1 where id in (1234556,123447) awk '{id [$1] = id [$1]? (Id [$1] "," $2): $2;} END {for (I in id) {print "select * from" I "_ post where id in (" id [I] ");"}'