sublime正则表达式去除sql的inert 语句某一列值

最新推荐文章于 2023-07-12 16:43:58 发布

Alvin_Lam

最新推荐文章于 2023-07-12 16:43:58 发布

阅读量520

点赞数

分类专栏：正则表达式 MySQL

本文链接：https://blog.csdn.net/Alvin_Lam/article/details/89187195

版权

本文介绍了如何利用Sublime Text的正则表达式功能，分两步删除SQL inset语句中`id`列的值。首先，去除`values('id_value',`之后的id值和逗号，然后移除`id`列的字段名和逗号。" 136951523,11319751,Java实现MySQL主从同步与读写分离,"['数据库', 'mysql', 'java', '读写分离', 'Spring']

摘要由CSDN通过智能技术生成

原SQL语句：

insert into `car_order_price_detail` (`id`, `parent_order_id`, `price_type`, `price_remark`, `selling_price`, `selling_price_currency`, `selling_price_rmb`, `cost_price`, `cost_price_currency`, `cost_price_rmb`, `operator`, `del_flag`, `create_time`, `update_time`, `fleet_code`) values('164639','1019053827','1','','10.00','CNY','0.00','10.00','CNY','0.00','系统','0','2018-09-20 20:59:54','2019-01-25 10:24:58','1');
insert into `car_order_price_detail` (`id`, `parent_order_id`, `price_type`, `price_remark`, `selling_price`, `selling_price_currency`, `selling_price_rmb`, `cost_price`, `cost_price_currency`, `cost_price_rmb`, `operator`, `del_flag`, `create_time`, `update_time`, `fleet_code`) values('164640','1040747467','1','','10.00','CNY','0.00','10.00','CNY','0.00','系统','0','2018-09-20 20:59:54','2019-01-25 10:24:58','1');
insert into `car_order_price_detail` (`id`, `parent_order_id`, `price_type`, `price_remark`, `selling_price`, `selling_price_currency`, `selling_price_rmb`, `cost_price`, `cost_price_currency`, `cost_price_rmb`, `operator`, `del_flag`, `create_time`, `update_time`, `fleet_code`) values('164641','1038950841','1','','10.00','CNY','0.00','10.00','CNY','0.00','系统','0','2018-09-20 20:59:54','2019-01-25 10:24:58','1');
insert into `car_order_price_detail` (`id`, `parent_order_id`, `price_type`, `price_remark`, `selling_price`, `selling_price_currency`, `selling_price_rmb`, `cost_price`, `cost_price_currency`, `cost_price_rmb`, `operator`, `del_flag`, `create_time`, `update_time`, `fleet_code`) values('164642','1029615674','1','','10.00','CNY','0.00','10.00','CNY','0.00','系统','0','2018-09-20 20:59:54','2019-01-25 10:24:58','1');
insert into `car_order_price_detail` (`id`, `parent_order_id`, `price_type`, `price_remark`, `selling_price`, `selling_price_currency`, `selling_price_rmb`, `cost_price`, `cost_price_currency`, `cost_price_rmb`, `operator`, `del_flag`, `create_time`, `update_time`, `fleet_code`) values('164643','1071706994','1','','10.00','CNY','0.00','10.00','CNY','0.00','系统','0','2018-09-20 20:59:54','2019-01-25 10:24:58','1');
insert into `car_order_price_detail` (`id`, `parent_order_id`, `price_type`, `price_remark`, `selling_price`, `selling_price_currency`, `selling_price_rmb`, `cost_price`, `cost_price_currency`, `cost_price_rmb`, `operator`, `del_flag`, `create_time`,