当前位置：网站首页>Database, add a field data of another table to another table, and add the data you need when adding at the same time

Database, add a field data of another table to another table, and add the data you need when adding at the same time

2022-04-21 12:08:00 【CSDN Q & A】

img


I want to put question_bank The question number in the question bank table is added to the middle table of the user's question bank , I don't just add question numbers , I want to add the student ID to each corresponding data How to operate



Take the answer ：

insert into student_question(student_id,question_id) select 5,id from question_bank;

版权声明
本文为[CSDN Q & A]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204142105401528.html

边栏推荐

猜你喜欢

随机推荐