【SQL】插入数据,从Select语句中获取

insert into
table_name
(
id,
name
)
(
select 
stu_id,
stu_name
from
stu_table
where
stu_id = #{stuId}
)

 

posted @ 2024-06-24 13:18  CEO雷总  阅读(42)  评论(0)    收藏  举报