对已查询的数据批量插入表中

[a1062656171]

INSERT INTO rz_userauthority (
rz_userauthority_uid,
rz_userauthority_authcode,
rz_userauthority_authcodevalue,
rz_userauthority_isvalid,
rz_userauthority_createdate,
rz_userauthority_type
)
VALUES
(
(select DISTINCT rz_userauthority_uid from rz_userauthority) ,
'300214',
'1',
1,
NOW(),
'ht'
)
如何让它能够执行。
select DISTINCT rz_userauthority_uid from rz_userauthority是查询出来多条数据，如何一次性插入。改怎么修改

[--小F--]

INSERT INTO rz_userauthority ( rz_userauthority_uid, rz_userauthority_authcode, rz_userauthority_authcodevalue, rz_userauthority_isvalid, rz_userauthority_createdate, rz_userauthority_type ) select DISTINCT rz_userauthority_uid from rz_userauthority , '300214', '1', 1, NOW(), 'ht'

[a1062656171]

这样是执行不了的。select DISTINCT rz_userauthority_uid from rz_userauthority是查询出来的不止一条的数据。通过insert into把id和'300214', '1', 1, NOW(), 'ht'插入。除了id不一样外，其余数据都一样。等于是插入数据的次数和去重查询出来id个数一样的。我说明白了吗

[a1062656171]

个人已解决。

[a1062656171]

INSERT INTO rz_userauthority ( rz_userauthority_uid, rz_userauthority_authcode, rz_userauthority_authcodevalue, rz_userauthority_isvalid, rz_userauthority_createdate, rz_userauthority_type ) select temp.rz_userauthority_uid, '300214', '1', 1, NOW(),'ht' from( select DISTINCT rz_userauthority_uid from rz_userauthority r ) temp;

[moudy]

哪有这么麻烦。 INSERT INTO rz_userauthority ( rz_userauthority_uid, rz_userauthority_authcode, rz_userauthority_authcodevalue, rz_userauthority_isvalid, rz_userauthority_createdate, rz_userauthority_type ) select DISTINCT rz_userauthority_uid, '300214', '1', 1, NOW(),'ht' from rz_userauthority

[a1062656171]

把40分给你吧