-----更改项目 select str1,* from project_info where projectid = '1712A00020100344' ; 1712A00020100344 文浅8 select str1,projectname from project_info where projectid = '1718A0005020021801' ; select str1,projectname from project_info where projectid = '1718A0005020021802' ; select str1,projectname from project_info where projectid = '1718A0005020021803' ; select str1,projectname from project_info where projectid = '1718A0005020021804' ; select str1,projectname from project_info where projectid = '1718A0005020021805' ; 1718A0005020021801 线路工程 1718A0005020021802 乐安阀室改建 1718A0005020021803 金浅8-3H平台外输计量阀组 1718A0005020021804----缺少 配套工程 1718A0005020021805 其他费用 select str1,projectname from project_info where projectid = '1716A00030200306' ; --缺少 永浅104井平台站地面集输工程 select str1,projectname from project_info where projectid = '1716A0003020030601' ; 永浅104井场、永法212-水浅104管线、水法104-水法203管线 select str1,projectname from project_info where projectid = '1716A0003020030602' ; 永浅203井改建 select str1,projectname from project_info where projectid = '1716A0003020030603' ; 水浅104平台集输(第二部分其他费用)