This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Reference: https://stackoverflow.com/a/61789978/7432026 | |
import pymysql | |
db = pymysql.connect(host="ak4483-db.cfut7pwibnyz.us-east-1.rds.amazonaws.com", user="admin", passwd="adm1nadm2n", database="question_9") | |
cursor = db.cursor() | |
for i, row in people.iterrows(): | |
person = **row | |
uni, firstName, lastName, email, role = person['uni'], person['first_name'], person['last_name'], person['email'], person['role'] | |
cursor.execute('INSERT INTO people (uni, firstName, lastName, email) VALUES(%s, %s, %s, %s)', uni, firstName, lastName, email) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
group: DB Final Q2 Test Data | |
description: DB Final Q2 Test Data | |
branch = { | |
branch_name, branch_city, assets | |
'Uptown', 'new york', 100 | |
'Beach', 'miami', 200 | |
'Dumpster', 'los angeles', 10 | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* Euler Approximation Scheme Script | |
* Anthony Krivonos | |
* Prof. Kei Kobayashi | |
* 9/25/2018 | |
*/ | |
/* | |
* Sample Function | |
* - Takes in (t, y) and returns a number. |