Streaming Twitter data into MySQL database

Purpose

This collection of scripts should be useful for those wishing to create a MySQL database connection and stream data using functions from the twitter API.

Set up

1. Make sure that you have created an empty database
2. Ensure that your local or remote server is running (can use the MySQL Notifier to make sure, or from MySQL Workbench)
3. Run the SQL script to create the appropriate table for storing the data

Streaming the data

1. Change the necessary variables for personal credentials in the python script
2. Run the script

Aknowledgements

Eric D. Brown, D.Sc. -- https://pythondata.com/collecting-storing-tweets-python-mysql/