利用IDEA 正则替换生成SQL语句

首先有一些数据, 每行用制表符隔开:

3414	71676
40110	71887
42440	68521
44833	71781
45577	71928
45703	71893
48492	71737
49712	71915
51872	71777
52690	71703
52765	72018
52784	71966
52826	71772
52912	72009
53109	71799
53130	71688

CTRL + R替换：
(.*)\t(.*)
UPDATE table1 SET user_id = $2 WHERE id = $1;
注意选中正则表达式:

replace all后得到结果如下：

UPDATE `table1` SET user_id = 71676 WHERE id = 3414;
UPDATE `table1` SET user_id = 71887 WHERE id = 40110;
UPDATE `table1` SET user_id = 68521 WHERE id = 42440;
UPDATE `table1` SET user_id = 71781 WHERE id = 44833;
UPDATE `table1` SET user_id = 71928 WHERE id = 45577;
UPDATE `table1` SET user_id = 71893 WHERE id = 45703;
UPDATE `table1` SET user_id = 71737 WHERE id = 48492;
UPDATE `table1` SET user_id = 71915 WHERE id = 49712;
UPDATE `table1` SET user_id = 71777 WHERE id = 51872;
UPDATE `table1` SET user_id = 71703 WHERE id = 52690;
UPDATE `table1` SET user_id = 72018 WHERE id = 52765;
UPDATE `table1` SET user_id = 71966 WHERE id = 52784;
UPDATE `table1` SET user_id = 71772 WHERE id = 52826;
UPDATE `table1` SET user_id = 72009 WHERE id = 52912;
UPDATE `table1` SET user_id = 71799 WHERE id = 53109;
UPDATE `table1` SET user_id = 71688 WHERE id = 53130;