import pymysql
def main():
     no=input('请输入你要删除的学生！')
     conn=pymysql.connect(host='39.98.119.160',port=3306,
                          user='root',password='123456',
                          db='school',charset='utf8')
     try:
         with conn.cursor() as cursor:
             # result=cursor.execute('insert into tb_student values(1012,"杨大小",1,"2020-1-1","永州",1)')
             result=cursor.execute(
                 'delete from tb_student where stuid=%s',(no,)
             )
             if result==1:
                 # print('添加成功')
                 print('删除成功')

             conn.commit()
     except pymysql.MySQLError as error:
         print(error)
         conn.rollback()
     finally:
         conn.close()

if __name__=='__main__':
     main()