小技巧

来源:互联网 发布:大学软件编程专业 编辑:程序博客网 时间:2024/04/29 16:59

在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 |

原创粉丝点击