Hi everyone, I need to bulk insert data into a Mysql table based on the information from another table and a dropdown. I don't have any idea how to do it...
What I do:
Thanks for the help.
Honza
1.) Create the components. Enable multi select on table. When you do this, table1.selectedRow.data will be an array of all selected rows' data.
2.) Create a SQL query. In it, put some Javascript code that will pull in the table data and the dropdown data and get it into the right format.
3.) For this JS code, use the map function. If you don't know about the map function, go read up on it, it's pretty useful for most things you'll want to do. Map returns an array of objects, which luckily is what the SQL query wants. Then it's just a matter of naming each object what the database expects. In this case, this little snipped should do just fine. Of course, you'll want to substitute the name "id_field" and the name "dropdown_field" with the names your database is expecting.
{{ table1.selectedRow.data.map(x => ({id_field: x.id, dropdown_field: select1.value})) }}
Check out the full picture below. Make sense?
@MarkR Hi Mark, thanks for the reply. I think it's clear (but javascript is no my strength 
). I will try it and will let you (and others) know. Thank you.
H.
@honzapav Mark’s reply above is definitely the way to go to build a re-usable app in Retool.
To do a one-time bulk insert (e.g. from a CSV) to MySQL, you can also use our Import CSV to MySQL Utility.
Just upload a CSV, make any changes to your data using the table editor, and run the auto-generated query in your MySQL client. You can also click “Run query in Retool” to auto-generate an app that writes to your database.
Let me know if you have any questions!
Hi @MarkR – I want to thank you. I have implemented your solution, and it works like expected. Thanks a lot!
Similar to Mark's question is it possible to pass an array into a Sql select without the Gui? I want to pass an array into a temp table, do etl on it and then insert it to a table in my database.
