mysql数据库增删改查

"""
author:张鑫
date:2021/7/30 11:31
"""
import pymysql
import requests
import re

import pymysql

connect = pymysql.Connect(
    host='140.210.4.73',
    port=3306,
    user='twipad_cj',
    passwd='bj@#twipad_cj',
    db='tw_ipaddb',
    charset='utf8mb4'
)
cursor = connect.cursor()
# 增加数据
sql1 = 'insert into kasaer(name,age,score) values (1,2,3)'
# 删除数据,1是字符串
# sql='delete from kasaer where name="1"'
# 修改数据
# sql='update kasaer set age=18,score=80 where name="路明非" '
# 查询数据
sql2 = 'select * from kasaer'
data1 = cursor.execute(sql1)
data2 = cursor.execute(sql2)
print(data1)
print(data2)
connect.commit()
print('修改成功')
connect.close()