Python MySQL Learning-output a result set of specified criteria

1 #Introducing the Pymysql module2 ImportPymysql as PM3 4 #Database Connection5db = Pm.connect (host='localhost', user='Root', password="123456", database='Task', charset='UTF8')6 #Creating Cursors7Cur =db.cursor ()8 #setting up SQL statements9sql ='SELECT * from Video_info WHERE actor_name=%s'Ten #Execute SQL statement OneCur.execute (SQL,'Andy Lau') A #Save a qualifying result set -Results =Cur.fetchall () - #Print result set the Print(Results) - #closing cursors and disconnecting database connections - cur.close () -Db.close ()

Test results:

Python MySQL Learning-output a result set of specified criteria