复制成功!

INSERT语句字段批量替换工具

使用示例:

输入INSERT语句:

INSERT INTO `tbl_commodity_corp_match_product` (`id`,`inside_barcode_id`) VALUES('76d08e68e7e4762d72e98b7a8b9d7d0a',null);
INSERT INTO `tbl_commodity_corp_match_product` (`id`,`inside_barcode_id`) VALUES('123456','20160623008161');

要替换的字段名: inside_barcode_id

替换值列表:

123123
456456

输出结果:

INSERT INTO `tbl_commodity_corp_match_product` (`id`,`inside_barcode_id`) VALUES('76d08e68e7e4762d72e98b7a8b9d7d0a','123123');
INSERT INTO `tbl_commodity_corp_match_product` (`id`,`inside_barcode_id`) VALUES('123456','456456');