MySQL Insert avatar
MySQL Insert
Try for free

No credit card required

View all Actors
MySQL Insert

MySQL Insert

petr_cermak/mysql-insert
Try for free

No credit card required

This act takes a crawler execution and inserts it's results into a remote MySQL database.

The code examples below show how to run the Actor and get its results. To run the code, you need to have an Apify account. Replace <YOUR_API_TOKEN> in the code with your API token, which you can find under Settings > Integrations in Apify Console. Learn more

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4client = ApifyClient("<YOUR_API_TOKEN>")
5
6# Prepare the Actor input
7run_input = {
8    "connection": {},
9    "proxyConfig": {
10        "useApifyProxy": True,
11        "apifyProxyGroups": ["qfCaFFuCodXxAS59E"],
12    },
13    "rows": [],
14    "staticParam": {},
15}
16
17# Run the Actor and wait for it to finish
18run = client.actor("petr_cermak/mysql-insert").call(run_input=run_input)
19
20# Fetch and print Actor results from the run's dataset (if there are any)
21print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
22for item in client.dataset(run["defaultDatasetId"]).iterate_items():
23    print(item)
24
25# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start
Developer
Maintained by Community
Actor metrics
  • 2 monthly users
  • 1 star
  • Created in Jul 2017
  • Modified 10 months ago