Importing data from CSV

Queries and Resources
1

I am trying to figure out a way to import data from a csv file into one of mysql tables. I saw the tutorial on how to do this, but it appears that the data that gets import is transient (session based maybe). I am trying to find a way to actually import and save this data to a table since I have ~220,000 rows.

I found a similar example that uses javascript, but wanted to find out if a more straightforward method exists before I re-invent the wheel.

2

Hey @jeffsupwork and welcome to the forum! Retool has a File Picker component that you can use to upload your CSV - from there on, you’ll just need to write a query that inserts the data into your MySQL database. Not sure what you mean by the import is transient?