sql查询出来a表的某个字段插入到b表中,同时向a表插入别的数据
RefundInfo_Config
字段
类型
为空
ID
Int
否
AccountId
Bigint
否
MaxAmount
Int
否
MinAmount
Int
否
RefundCount
Int
否
Rate
Int
否
WeekDay
Int
否
select distinct accountId from B_AccBankPOS_Share where createtime>=2012-6-1这个是查a表的
想把查询出来的数据加上1,10000,500,1,80,5插入到b表中
insert into RefundInfo_Config (AccountId,MaxAmount,MinAmount,RefundCount,Rate,[WeekDay]) select distinct accountId from B_AccBankPOS_Share where createtime>=2012-6-1,10000,500,1,80,5
这样写不对。求指点
4 回答

神不在的星期二
TA贡献1963条经验 获得超6个赞
把SQL语句改为:
insert into RefundInfo_Config (AccountId,MaxAmount,MinAmount,RefundCount,Rate,[WeekDay]) select distinct accountId,10000,500,1,80,5 from B_AccBankPOS_Share where createtime>='2012-6-1'

慕斯王
TA贡献1864条经验 获得超2个赞
1 insert into RefundInfo_Config (AccountId,MaxAmount,MinAmount,RefundCount,Rate,[WeekDay])
values (select distinct accountId from B_AccBankPOS_Share where createtime>=2012-6-1),
10000,500,1,80,5

慕斯709654
View Code
TA贡献1840条经验 获得超5个赞

insert into RefundInfo_Config (AccountId,MaxAmount,MinAmount,RefundCount,Rate,[WeekDay]) values((select distinct accountId from B_AccBankPOS_Share where createtime>=2012-6-1), 10000,500,1,80,5)

萧十郎
TA贡献1815条经验 获得超13个赞
insert into RefundInfo_Config (AccountId,MaxAmount,MinAmount,RefundCount,Rate,[WeekDay])
select distinct accountId,10000,500,1,80,5 from B_AccBankPOS_Share where createtime>=2012-6-1
这下应该行了
- 4 回答
- 0 关注
- 1151 浏览
添加回答
举报
0/150
提交
取消