mysql - Use PHPEXCEL to import 5000+ items of data from an excel file into the database. The local database is normal, but only 15 items are imported online. No errors are reported. What is the problem?

Question

Use PHPEXCEL to import 5,000 items of data from the excel file into the database. The local database is normal, but only 15 items are imported online. The EXCEL file can be converted into an array normally, but only 15 items are imported, and the execution time is set to setlimittim 0.
Which part is the problem? ? Thanks to everyone who answered.

Answer 1

How many pieces of data are there when you convert excel content into data in the local test environment? Or you have a field that is empty, but the data table setting is not empty, so the data cannot be inserted into the database

Answer 2

There is abnormal data, and the table has other constraints.

You can try to import 5000+ into the test database to find abnormal data.