Insert multiple statements into the database

Question

The teacher asked to make an exam arrangement system, select the course name, time, location and multiple student IDs, and insert them into the database at the same time. We are not professional in writing code, so we really can’t figure it out. Please help me, please help me. It crashed after making it...

Answer 1

Teacher Peter-Zhu’s answer is correct, that’s it

Answer 2

You can use: INSERT data table (field list) VALUES (value list 1), (value list 2), (value list 3)..., of course, you can also INSERT table name SET field = value, which is more efficient. some.