Python操作Mysql

最新推荐文章于 2024-07-15 17:46:33 发布

douyunqian668

最新推荐文章于 2024-07-15 17:46:33 发布

阅读量377

点赞数

分类专栏： Python高级编程

本文链接：https://blog.csdn.net/douyunqian668/article/details/51505822

版权

Python高级编程专栏收录该内容

107 篇文章 1 订阅

订阅专栏

#coding=utf-8
import xlwt,MySQLdb
#第一步创建连接
coon=MySQLdb.connect(host='127.0.0.1',user='host',passwd='',db='test',port=3306)
#第二步创建游标
cuor=coon.cursor()
#插入数据
cuor.execute("insert into msg (title,name,content) values ('python','zz01','tset mysql inserts')")
coon.commit()
import time
now=time.strftime("%Y:%m:%d")
print(now)

sql=("insert into msg (title,name,content) values (%s,%s,%s)")
cuor.executemany(sql,[('test07','zz07','Do many lovd'),('tes08','zz09','fsdfsd')])
coon.commit()

import random
sql="insert into user (name,gender) values"
for i in range(100):
    sql+="('user"+str(i)+"',"+str(random.randint(0,1))+"),"
sql=sql[:-1]
print(sql)
cuor.execute(sql)
coon.commit()
cuor.execute("select * from user")#执行查询表语句
print(cuor.fetchall())
print(cuor.fetchall())#无显示，表示游标到最后了
cuor.scoll(1,mode='absolute')#从开始的第一行，移动values条，而此刻的value是1
print cuor.fetchmany(2)
cuor.scoll(1,mode='relative')#从当前行向后移动value行，此时此刻value是1
print(cuor.fetchmany(1))#显示第4行的数据