mysql optimization - the situation behind mysql update, delete and insert operations on multiple pieces of data

Question

1.Update, delete and insert operate multiple pieces of data, adding, modifying and deleting one by one. Is this correct?
2. Is there any way to prove it?

Answer 1

Read the documentation yourself, this kind of question is too unhelpful.
Whether a statement is executed correctly, the SQL engine will report it.

In addition, insert can insert many rows of data at one time. Please refer to the values ​​syntax for the specific method.