pyMysql.py

import pymysql

conn = pymysql.connect(host='localhost', port=3356, user='root', passwd='1234', db='dev')

cur = conn.cursor()

#cur.execute("CREATE TABLE coda (id int(11) not null AUTO_INCREMENT, name varchar(20) null, age int(2) null, PRIMARY KEY(id))")
cur.execute("INSERT INTO coda (name, age) VALUES ('hafid', 33)")
conn.commit()
cur.execute("SELECT * FROM coda")
#results = cur.fetchall()

print()

for row in cur:
    print(row)

cur.close()
conn.close()