小技巧

在notepad++，按住ALT可以选择矩形区域

 

下面的情况就可以派上用场了

INSERT INTO file_server SELECT 36144595,server_id FROM file_server WHERE cdnfile_id=0;
INSERT INTO file_server SELECT 36144601,server_id FROM file_server WHERE cdnfile_id=0;
INSERT INTO file_server SELECT 36144598,server_id FROM file_server WHERE cdnfile_id=0;
INSERT INTO file_server SELECT 36144599,server_id FROM file_server WHERE cdnfile_id=0;
INSERT INTO file_server SELECT 36144596,server_id FROM file_server WHERE cdnfile_id=0;
INSERT INTO file_server SELECT 36144597,server_id FROM file_server WHERE cdnfile_id=0;
INSERT INTO file_server SELECT 36144600,server_id FROM file_server WHERE cdnfile_id=0;
INSERT INTO file_server SELECT 36144593,server_id FROM file_server WHERE cdnfile_id=0;
INSERT INTO file_server SELECT 36144594,server_id FROM file_server WHERE cdnfile_id=0;

| 36144595 |
| 36144601 |
| 36144598 |
| 36144599 |
| 36144596 |
| 36144597 |
| 36144600 |
| 36144593 |
| 36144594 |

转载于:https://www.cnblogs.com/miraclespace/archive/2010/11/04/3712423.html