import pymysql
db = pymysql.connect(host='',port=,user='',password='',database='')
cursor=db.cursor()
cursor.execute('select * from 表名')
reslut=cursor.fetchone()
print(reslut)
sql
db = pymysql.connect(host='',user='',password='',port=,database='')
cursor=db.cursor()
'''sql="insert into article(id,title,content) values(null,'222','333')"
cursor.execute(sql)'''
title='777'
content='999'
sql="insert into article(id,title,content) values(null,%s,%s)"
cursor.execute(sql,(title,content))
'''
title=777
content=999
sql="insert into article(id,title,content) values(null,'%s','%s')"
cursor.execute(sql,(title,content))
'''
db.commit()
db.close()
import pymysql
db=pymysql.connect(host='',user='',password='',port=,database='')
cursor=db.cursor()
sql="select * from 表名"
cursor.execute(sql)
result=cursor.fetchmany(2)
print(result)
db.commit()
db.close()
import pymysql
db=pymysql.connect(host='',user='',password='',port=,database='')
cursor=db.cursor()
'''sql="delete from article where id=2" #不加条件就会全部删除 也可以>=删除多条
cursor.execute(sql)
'''
'''sql="update article set title='修改的东西' where id=3" #如果有时候编码报错 可以在db加上 charset=‘utf8’这个参数
cursor.execute(sql)
'''
db.commit()
db.close()