我需要复制一张表的一行数据并替换其中一个字段的值，然后直接添加到该表

[w3edcv]

"INSERT INTO FrmBasicData SELECT :newName,iBuildTime,iProjectNum,iOperator,iDetector,iGearName,iGearNum,iGearUser,iWormName,iWormSupplier,iWormNum,iDresserName,iDresserSupplier,iDresserNum,iFixtureNameiFixtureName,iFixtureSupplier,iFixtureNum FROM FrmBasicData WHERE iProjectName=:oldName"
程序是用QT写的，不知道这个SQL语句哪里有错？
还是说有另外的更简单的方法？急求。

该表中的字段就比后面select的多了一个ID（自动编号）和iProjectName（用:newName的值赋给复制后的该字段）

[w3edcv]

引用 1 楼 beck464771647 的回复:

INSERT INTO FrmBasicData(newName,iBuildTime,iProjectNum,iOperator,iDetector,iGearName,iGearNum,iGearUser,iWormName,iWormSupplier,iWormNum,iDresserName,iDresserSupplier,iDresserNum,iFixtureNameiFixtureName,iFixtureSupplier,iFixtureNum) SELECT :newName,iBuildTime,iProjectNum,iOperator,iDetector,iGearName,iGearNum,iGearUser,iWormName,iWormSupplier,iWormNum,iDresserName,iDresserSupplier,iDresserNum,iFixtureNameiFixtureName,iFixtureSupplier,iFixtureNum FROM FrmBasicData WHERE iProjectName=:oldName

试过，一样不行

[ACMAIN_CHM]

insert into ... select ... 中的字段必须严格一一匹配。 如果表中有ID字段，可以使用 insert table x select null as id, col1,col2,col3 from

[足球不是方的]

INSERT INTO FrmBasicData(newName,iBuildTime,iProjectNum,iOperator,iDetector,iGearName,iGearNum,iGearUser,iWormName,iWormSupplier,iWormNum,iDresserName,iDresserSupplier,iDresserNum,iFixtureNameiFixtureName,iFixtureSupplier,iFixtureNum) SELECT :newName,iBuildTime,iProjectNum,iOperator,iDetector,iGearName,iGearNum,iGearUser,iWormName,iWormSupplier,iWormNum,iDresserName,iDresserSupplier,iDresserNum,iFixtureNameiFixtureName,iFixtureSupplier,iFixtureNum FROM FrmBasicData WHERE iProjectName=:oldName

[w3edcv]

引用 3 楼 ACMAIN_CHM 的回复:

insert into ... select ... 中的字段必须严格一一匹配。 如果表中有ID字段，可以使用 insert table x select null as id, col1,col2,col3 from

谢了，自己搞定了，貌似是我从access里复制字段名称到VS里，然后有问题，自己手动输入就没错了，心累