create global temporary table a as select column_desc from admin_configcolumnv on row preserve commit;update admin_configcolumnv set detail = (select column_desc from a);
当然不行,你这一句的set detail = 之后必须是一个确定值。就是说数据库对每行的set时,必须保证只选到一个值,不然叫系统帮你插入哪个值?改为:update admin_configcolumnv set detail = column_desc 就可以了
你的这个select 返回的是一个结果集不能直接付给一个字段。按下面即可update admin_configcolumnv A set detail = (select column_desc from admin_configcolumnv B where A.主键=B.主键)
update admin_configcolumnv set detail = column_desc 就可以了
as
select column_desc from admin_configcolumnv
on row preserve commit;update admin_configcolumnv set detail = (select column_desc from a);