The inimitable Norman Palardy wrote a CSV parser which acts like a recordset. You can find it here: GitHub - npalardy/CSVParser: Event based and recordset like CSV parser for Xojo
You can read the CSV file record by record and insert the values into your MySQL table.