MySQL触发器将第一个表的数据插入后插入第二个表

Question

Here are my tables.Student Table+++++++++++++++++++++++++++++++++++++++++++++++++++| s_id |    name     |   lname    | fname    | c_id |+++++++++++++++++++++++++++++++++++++++++++++++++++|  1   |     ali     |   ahmadi   | ahmad    |  1   ||  2   |  Hussain    |   Sharan   | Skekib   |  2   ||  3   |  Mahmood    | Shekibayee | Jahangir |  1   |+++++++++++++++++++++++++++++++++++++++++++++++++++Student_course Table+++++++++++++++++++++++| sc_id | s_id | c_id  |++++++++++++++++++++++|  1    |  1   |   1   ||  2    |  2   |   1   ||  3    |  3   |   2   |++++++++++++++++++++++Now I want to have a trigger that:When I insert new student into `student` table it should insert `s_id` and `c_id` into student_Coursetable.I am quite new to PHP and MySQL; any help will be highly appreciated.Thanks in advance.

Answer 1

假设 sc_id 是 Student_course 上自动递增的主键，这可能相当简单

delimiter //
create trigger ins_student_course after insert on Student
for each row 
begin
 insert into Student_course (s_id,c_id) values (new.s_id,new.c_id);
end ;//

delimiter ;