python use mysql SELECT is success but Still will error:1054 Unknown column ’emotic’ in ‘field list’
sql = """SELECT * FROM music WHERE emotic=%s ORDER BY RAND() LIMIT 1"""
music=cursor.execute(sql, (most_common_key,))
music = cursor.fetchone()
print(music)
enter image description here
New contributor
AaA AAa is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.