Insert multiple statements into the database
Ettie Mao
Ettie Mao 2018-01-13 14:46:38
0
2
1114

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...

Ettie Mao
Ettie Mao

reply all(2)
凌波漫步

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

Peter_Zhu

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.

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template