How to make data sampling from a text file and transfer this data to mysql? in a text file, the data are given in columns and each of these columns must be entered into different fields in the database

  • Add a small part of the file to the question to understand the data format - webDev_
  • LOAD DATA INFILE - Akina

1 answer 1

Most likely we are talking about the ".csv" format, if so, then the text file can be imported directly via the phi interface's gui interface in the import file tab.