DataFrame_to_sql

DataFrame_to_sql.py

import mysql.connector
mydb = mysql.connector.connect(
    host='localhost',
    user='root',
    password='****',
    database='football_db'
)
print(mydb)
print(players_data.columns)

cursor = mydb.cursor()

query = '''CREATE TABLE player_data
( Name text(255), Age int(10), Nationality text(255), Overall int(10), Potential text(255), Club text(255),
        Value_Millions int(10)… 

);'''

cursor.execute(query)

players_data.to_sql(name='player_data', con=engine, index=False, if_exists='append')