torndb在python3中运用

 

 

#连接数据库:
db = torndb.Connect()

#查询一条的数据
get()

#查询多行的数据
query()

#创建数据表，数据库
execute()

#插入一条数据:
sql = "insert into user(username,password) values(%s,%s)"
db.insert(sql,"张三","kkk")

#一次插入多条数据
sql = "insert into user(username,password) VALUES (%s,%s)"
db.insertmany(sql,[
    ("user10","kkkkkkkkk"),
    ("user11","kkkkkkkkk"),
    ("user12","kkkkkkkkk"),
    ("user13","kkkkkkkkk"),
    ("user14","kkkkkkkkk"),
    ("user15","kkkkkkkkk"),
    ("user16","kkkkkkkkk"),
    ("user17","kkkkkkkkk"),
    ("user18","kkkkkkkkk"),
])

#更新数据
sql = "update user set username= %s"
db.update(sql,"大雷哥")

#删除数据
sql ="delete from user where id =1"
db.execute(sql)

#插入并返回插入行的id
sql ="insert into user(username,password) VALUES(%s,%s)"
result_id = db.execute_lastrowid(sql,"bruce","kkk")

#批量插入，但是返回插入的第一行的id
sql ="insert into user(username,password) VALUES(%s,%s)"
result_id = db.executemany_lastrowid(sql,[
    ["王星辰宇","123"],
    ["tom","123"],
    ["jack","123"],
    ["alex","123"],
])

#返回影响的行数
sql ="delete from user where id>20"
result_id = db.execute_rowcount(sql)


moidfy vs change内容

 

转载于:https://www.cnblogs.com/leigepython/p/9055917.html