python-flask mysql数据库交互语句

1.导入pymsql

import pymysql

2.数据库条件查询语句

db = pymysql.connect("localhost", "root", "", "test")
cursor = db.cursor()
cursor.execute("select * from user where username=%s and password=%s", (user_name,user_pwd))
db.commit()

3.数据库条件更新语句

db = pymysql.connect("localhost", "root", "", "test")
cursor = db.cursor()
cursor.execute("UPDATE work SET off=%s , deltime=%s where username=%s and dates=%s",
((now2),(b-a),user_name,date))
db.commit()

4.数据库插入语句

db = pymysql.connect("localhost", "root", "", "test")
cursor = db.cursor()
cursor.execute("INSERT INTO user(username,password,email,age,birthday)values (%s,%s,%s,%s,%s)",
                       (user.name,user.pwd,user.email,user.age,user.birthday))
db.commit()