# This script needs mysql driver:
# pip3 install mysql

import MySQLdb

db = MySQLdb.connect(host  ="hoschis-tippspiel.de",  # your host, usually localhost
                     user  ="d0274241",              # your username
		     passwd="superpfosten!",         # your password
		     db    ="d0274241")              # name of the data base

# you must create a Cursor object. It will let
#  you execute all the queries you need
cur = db.cursor()

# Use all the SQL you like
cur.execute("SELECT * FROM seasons")
		       
# Column namnes
arr=[]
for i in range(0,len(cur.description)):
    arr.append(cur.description[i][0])
print(";".join(arr))

for row in cur.fetchall():
    print (row)
print("---")


db.close()