MySQL导数据报错[Err] 1241 - Operand should contain 1 column(s)

这个语句的出现多是因为将select 的结果集用()包住了。

原来的sql：

insert into ubi_user_company (organization,organizationName)
select (a.organization,a.organizationName) from bigdata_fee_user_info_200412 a where a.userId is not null

修改后的sql：

insert into ubi_user_company (organization,organizationName)
select a.organization,a.organizationName from bigdata_fee_user_info_200412 a where a.userId is not null