PYTHON CASE STUDY – 1 And CASE STUDY - 2 FOR PYTHON WITH SQL

Опубликовано: 21 Октябрь 2024
на канале: proco
61
2

SQL With PYTHON Question No-1
Your friend VINNY writing a code to fetch data from a database Shop and table name Products using Python. He has written incomplete code. You have to help him write complete code:
import ________________ as m Statement-1
object1 = m.connect(host="local host", user="root", password="root", database="Shop“ )
object2 = object1.______________ Statement-2
query = '''SELECT * FROM Products WHERE NAME LIKE "A%";'''
object2._______(query) Statement-3
object1.close()

#education #computerscience #tutorial #computers #python #pythonprogramming #pythontutorial #pythonforbeginners #pythonbeginner