Python fetchall示例

示例#1

def _update(sql, args):
    val = (args[1], args[0])
    mycursor.execute(sql, val)
    mydb.commit()
    print(mycursor.rowcount, "record updated")
    mycursor.execute("SELECT * FROM client")
    myresult = mycursor.fetchall()
    for x in myresult:
        print(x)

示例#2

文件： 10-show_one_client.py 项目： torres1-23/challenges-SQL

#!/usr/bin/python3
"""Deletes a client record in the database boli_assurance of SQL"""
import mysql.connector
import sys
from database_connect import mydb, mycursor
from tabulate import tabulate

sql = ("SELECT * FROM client WHERE id_client=%s")
args = sys.argv
val = (int(args[1]), )
mycursor.execute(sql, val)
myresult = mycursor.fetchall()
for x in myresult:
    print(
        tabulate(
            myresult,
            headers=['id_client', 'first_name', 'last_name', 'phone', 'email'],
            tablefmt='psql'))