原始SQL:INSERT INTO cbc_organize_agent_number_pool (agent_id,agent_code,agent_name,number,have_been_used)VALUES('4','2',NULL,'BS040499730CN','1');
需求:需要将中间的运单号替换为新的值,并且更改运单号状态为0.
方法:excel中公式写法:=“ INSERT INTO cbc_organize_agent_number_pool (agent_id,agent_code,agent_name,number,have_been_used)VALUES('4','2',NULL,' ” &A1& " ','1'); "
然后,直接拖拽单元格右下角的十字光标下拉即可