crsr.execute('SELECT firstname FROM pytest LIMIT 0, 1')
fname = crsr.fetchone()[0]
print(fname)
crsr.execute('SELECT firstname FROM pytest')
Python MySQL connector - unread result found when using fetchone