Here is an example to download data from a SQL database:
mySQLconnection = mysql.connector.connect(host="cpanel.insaid.co",
database='Capstone1',
user='student',
password='student')
sql_select_Query = "select * from phone_brand_device_model"
cursor = mySQLconnection .cursor()
cursor.execute(sql_select_Query)
phone = pd.DataFrame(cursor.fetchall())
phone.columns = cursor.column_names
cursor.close()
mySQLconnection.close()
Comments
0 comments
Article is closed for comments.