1.初学mysql

安装pymysql (终端运行)

pip install pymysql

建立数据库连接

def query_records():
    db = connect(
        host="localhost", 
        user="root",
        password="123456",
        database="mydb",
        port=3306
    )

创建游标对象:

cursor = db.cursor() 

查询语句

cursor = db.cursor()  # 将 connect 改为 cursor
    s_name = "子龙"
    #
    sql="SELECT * FROM s WHERE s.name='{}'".format(s_name)


    try:
        cursor.execute(sql)
        print("查询成功")
        res=cursor.fetchall()
        print(res)



    except Exception as e:
        print(e)
    db.close()

运行

if __name__=="__main__":
    query_records()

完整代码

from pymysql import *

def query_records():
    db = connect(
        host="localhost",
        user="root",
        password="123456",
        database="mydb",
        port=3306
    )

    cursor = db.cursor()  # 将 connect 改为 cursor
    s_name = "子龙"
    #
    sql="SELECT * FROM s WHERE s.name='{}'".format(s_name)


    try:
        cursor.execute(sql)
        print("查询成功")
        res=cursor.fetchall()
        print(res)



    except Exception as e:
        print(e)
    db.close()
if __name__=="__main__":
    query_records()