用Python操作SQL语句

Question

这貌似是个考题来着，尽量简单易懂的用Python解这些问题，（请各位解答者顺便标注一下每一块的步骤都是解释哪个问题，栓Q）

Answer 1

from pymysql import connect
def sql(Sql):
  mydb = connect(
    host="localhost",
    user="yourusername",
    passwd="yourpassword"
  )

  mycursor = mydb.cursor()
  mycursor.execute(Sql)
  mycursor.close()
# 每一个sql对应一个句式
sql("create database products character set utf8;")
sql("CREATE table p1(id VARCHAR(4),`name` VARCHAR(10) ,`type` VARCHAR(5),price INT(5),PRIMARY key(id));")
lis=[['A001','电视机','家电',5000],['A002','音响','家电',1000]]
for i in lis:
    sql("insert into p1 values('%s','%s','%s','%s') "%(i[0],i[1],i[2],i[3]))
sql("alter table p1 add sale_num int(3)")
sql("select * from p1 where price>2000 and sale_num>50")
sql("update p1 set price=price*0.9  where sale_num<50)")
sql("select id,name from p1 where type='家电'")
sql("alter table p1 modify price int(8)")
sql("delete from p1 where name='电视机'")
sql("drop table p1")