Php reads the 50m exell file and then writes it to the database. Is there any good way to do it?

is there any good way for php to read a 50m exell file and then write it to the database? It is about 100w pieces of data

Apr.13,2022

use yield for processing, please refer to https://blog.csdn.net/guyan03...

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bea1e7-30d2d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bea1e7-30d2d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?