import numpy as np
import pandas as pd
import pymysql

conn = pymysql.connect(host="127.0.0.1", user="root", passwd="Eszqsc1234", db="mysql", use_unicode=True, charset="utf8")
cur = conn.cursor()
cur.execute("USE scraping")

results = pd.read_sql_query("SELECT * FROM protNews", conn)
results.to_csv("output_with_sport.csv", index=False, index_label="id")
bf8e181499722c08e428941a6a39015aa1caae04
<mask token>

<mask token>
cur.execute('USE scraping')
<mask token>
results.to_csv('output_with_sport.csv', index=False, index_label='id')

<mask token>
conn = pymysql.connect(host='127.0.0.1', user='root', passwd='Eszqsc1234',
    db='mysql', use_unicode=True, charset='utf8')
cur = conn.cursor()
cur.execute('USE scraping')
results = pd.read_sql_query('SELECT * FROM protNews', conn)
results.to_csv('output_with_sport.csv', index=False, index_label='id')

import numpy as np
import pandas as pd
import pymysql
conn = pymysql.connect(host='127.0.0.1', user='root', passwd='Eszqsc1234',
    db='mysql', use_unicode=True, charset='utf8')
cur = conn.cursor()
cur.execute('USE scraping')
results = pd.read_sql_query('SELECT * FROM protNews', conn)
results.to_csv('output_with_sport.csv', index=False, index_label='id')

import numpy as np
import pandas as pd
import pymysql

conn = pymysql.connect(host="127.0.0.1", user="root", passwd="Eszqsc1234", db="mysql", use_unicode=True, charset="utf8")
cur = conn.cursor()
cur.execute("USE scraping")

results = pd.read_sql_query("SELECT * FROM protNews", conn)
results.to_csv("output_with_sport.csv", index=False, index_label="id")