python+mysql : mysql.connector.errors.InterfaceError: No result set to fetch from

Question

when query in PHPMyAdmin the result shows, but when query in python the error mysql.connector.errors.InterfaceError: No result set to fetch from. enter image description here

this code can run for data in every year except 2019

select_mysql3 = """ select priceClose from stock_history where symbol = '%s' order by pricingDate desc limit %s  """ % (stock)

print(select_mysql3)
mysql_db3.execute(select_mysql3)
result_mysql3 = mysql_db3.fetchall()