一、PyMysql连接数据库
1、先安装pymysql模块
pip install PyMySQL
2、导入pymysql模块
3、连接数据库
conn=pymysql.connect(host='localhost',
user='root',
passwd='123456',
port=3306,
db='test1',
charset='utf8')
cur=conn.cursor() #创建游标对象
sql='select * from music' #创建sql语句
cur.execute(sql) #执行sql语句
data=cur.fetchall()
print(data) #查看sql语句执行的结果
cur.close() #关闭游标
conn.close() #关闭连接
二、用Python对数据库进行增删改查
1、增
import pymysql
conn=pymysql.connect(host='localhost',
user='root',
passwd='123456',
port=3306,
db='test1',
charset='utf8')
cur=conn.cursor(cursor=pymysql.cursors.DictCursor) #查询的结果以字典的形式显示
sql_insert='insert into music(music_name,singer,date) values("missing you","gd",now())'
cur.execute(sql_insert)
conn.commit()
cur.close()
conn.close()
2、删(只写sql语句,其他省略,下同)
sql_delete='delete from music where music_id=2'
cur.execute(sql_delete)
3、改
sql_update='update music set singer="kc" where music_name="ill"'
cur.execute(sql_update)
4、查
sql='select * from music'
cur.execute(sql)