
MySQL Insert
Pricing
Pay per usage

MySQL Insert
This act takes a crawler execution and inserts it's results into a remote MySQL database.
0.0 (0)
Pricing
Pay per usage
1
Monthly users
1
Last modified
2 years ago
JSON example not working in JSON editor
I copied the JSON example into the JSON box, updated the connection details to my remote mySQL DB. There is an error that says "Error: Cannot start actor run (Field "connection" is required)"

can you show me a task or run that you're having issues?
stizzi
Sure. I'm copying this into "JSON" and hitting run.
{ "connection": { "host" : "hostname", "user" : "admin", "password" : "pass", "database" : "dbname", // optional "port" : 3306 // optional }, "table": "test", "rows": [ {"column_1": "value_1", "column_2": "value_2"}, {"column_1": "value_3", "column_2": "value_4"} ] }

that's just an example of how the input should look like, JSON doesn't allow comments, //optional are comments
Pricing
Pricing model
Pay per usageThis Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage.