sql查询出来a表的某个字段插入到b表中，同时向a表插入别的数据

Question

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

 

这样写不对。求指点

Answer 1

把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'

Answer 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

Answer 3

View Code 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)

Answer 4

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 这下应该行了