code

Sample Python Code

Install MySQL connector by command

pip install mysql-connector-python

Directions to install SQL Server pyodbc connector

Sample Python Code Files

• Python MySQL Query Example (.py), Python MySQL Query Example (.ipynb)
• Python MySQL Query Example with Parameters (.py), Python MySQL Query Example with Parameters (.ipynb)
• Python MySQL Insert/Delete Example (.py), Python MySQL Insert/Delete Example (.ipynb)
• Python SQL Server Example (.py), Python SQL Server Example (.ipynb)
• Python SQLite Example (.py)

Sample R Code

Sample R Code Files

• MySQL - R MySQL Example (.r)
• Microsoft SQL Server - R Microsoft SQL Server Example (.r)
• SQLite - R SQLite Example (.r)
• dplyr/dbplyr - R dplyr Example (.r)