34,873
社区成员
发帖
与我相关
我的任务
分享为什么Insert.....select语句不能运行
tb_checkrecord和tb_waitdeal表的结构是一样的
insert into tb_checkrecord
select uid from tb_waitdeal
错误提示如下：
Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
insert into tb_checkrecord
select uid from tb_waitdeal
错误提示如下：
Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
...全文
请发表友善的回复…
发表回复
happydreamer 2003-05-30
- 打赏
- 举报
类型不匹配要做转换
yzssg 2003-05-30
- 打赏
- 举报
列数或类型不匹配
pbsql 2003-05-29
- 打赏
- 举报
两表的字段类型不匹配（没有一一对应）
yoki 2003-05-29
- 打赏
- 举报
选择的列的数目必须和遥要插的列的数目一样
也可以
insert into tb_checkrecord
select * from tb_waitdeal
也可以
insert into tb_checkrecord
select * from tb_waitdeal
yoki 2003-05-29
- 打赏
- 举报
insert into tb_checkrecord (uid)
select uid from tb_waitdeal
select uid from tb_waitdeal
xirumin 2003-05-29
- 打赏
- 举报
up
