#importpymysqlmoduleimportpymysql#connectdatabaseconn=pymysql.connect(host="localhost",user="root",password="123456",database="fanis",charset="utf8")#获取游标cursor=conn.cursor()#创建表sql="""如果不存在则创建表user(idINTauto_incrementPRIMARYKEY,nameCHAR(10)NOTNULLUNIQUE,ageTINYINTNOTNULL);"""cursor.execute(sql)#清表数据sql="TRUNCATETABLEuser;"cursor.execute(sql)#插入数据sql="insertintouser(name,age)values('july',14);"cursor.execute(sql)sql="insertintouser(name,age)values('june',25);"cursor.execute(sql)sql="insertintouser(name,age)values('marin',36);"cursor.execute(sql)#查询并打印结果sql="select*fromuser;"cursor.execute(sql)foritemincursor.fetchall():print(item)#注意向写操作提交conn.commit()#关闭连接cursor.close()conn.close()
