python操作mysql

最新推荐文章于 2024-10-02 12:42:27 发布

在踩坑中前进

最新推荐文章于 2024-10-02 12:42:27 发布

阅读量548

点赞数

分类专栏： python 文章标签： mysql python 数据库

本文链接：https://blog.csdn.net/zhaoyahui_666/article/details/122223917

版权

python 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

安装

pip install pymysql

插入

import pymysql
conn = pymysql.connect(host='ip',user="root",passwd="pwd",db="dbname")
cursor=conn.cursor()
cursor.execute('insert into Person (Name,Age) values (\"{}\",{})'.format('你是谁',33))
cursor.close()
conn.commit()
conn.close()
print('end')

修改

import pymysql
conn = pymysql.connect(host='ip',user="root",passwd="pwd",db="dbname")
cursor=conn.cursor()
cursor.execute('update Person set Name="{}\",Age={} where id=31'.format('哈哈哈',44))
cursor.close()
conn.commit()
conn.close()
print('end')

删除

import pymysql
conn = pymysql.connect(host='ip',user="root",passwd="pwd",db="dbname")
cursor=conn.cursor()
cursor.execute('delete from Person where id=31')
cursor.close()
conn.commit()
conn.close()
print('end')

查询

import pymysql
conn = pymysql.connect(host='ip',user="root",passwd="pwd",db="dbname")
cursor=conn.cursor()
cursor.execute('select * from Person')
while 1:
    res=cursor.fetchone()
    if res is None:
        #表示已经取完结果集
        break
    print (res)
cursor.close()
conn.commit()
conn.close()
print('end')