How much data will be lost after a single insert in mysql?

I want to use PHP to execute a SQL statement to insert data in batches. I heard others say that too much data will cause data loss problems. Please tell me why this problem occurs. Generally, how much data can be inserted in batches to ensure that the data will not be lost.

Reply content:

I want to use PHP to execute a SQL statement to insert data in batches. I heard others say that too much data will cause data loss problems. Please tell me why this problem occurs. Generally, how much data can be inserted in batches to ensure that the data will not be lost.

Lost data is because the application is not written well and has nothing to do with mysql. It depends on your current memory size and system load. Generally, you can start testing with 1,000 entries each time. Experience data