python--pamysql数据库连接+执行查询语句

#!/usr/bin/python3
# -*- coding: utf-8 -*-
# @Date  : 2021/6/2
# @Name  : ZhouZongXin

"""

"""
import pymysql


# 数据库连接
def connect_mysql():
    try:
        connect = pymysql.connect(host='localhost',
                                  user='root',
                                  password='root',
                                  database='test', port=3306, charset='utf8')
    except Exception as e:
        print("连接数据库失败：", e)
    return connect


def select(name):
    db = connect_mysql()
    cur = db.cursor()  # 创建游标

    sql = "select * from xc_qa where qa_name=%s"
    print(sql)

    cur.execute(sql, [name])  # 执行sql语句（sql， 要传递的参数）
    # print(cur.fetchone())  # cur.fetchone()查询第一条数据
    # print(cur.fetchmany(2))  # cur.fetchmany(2)查询第x条数据
    print(cur.fetchall())  # cur.fetchall()查询所有数据

    db.close()  # 关闭数据库
    cur.close()  # 关闭游标


if __name__ == '__main__':
    name = input("要查询的名字：")
    select(name)

终端命令：

启动：sudo mysql.server start
状态：sudo mysql.server status
关闭：sudo myql.server stop

进入mysql命令： /usr/local/mysql/bin/mysql -u root -p

如果报错（Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)）执行：/usr/local/mysql/bin/mysql -uroot -h 127.0.0.1 -p

输入你的密码：xxxx

展示数据库：show databases
切换数据库： use 数据库名称
展示数据库中的表: show tables
创建数据库: create database test
创建表: create table test(id int,name varchar(20))
插入数据：insert into test values(1,“aaa”)
更新数据：update test set name=“updatename” where id = 2
删除数据库：drop database test
删除表的数据：delete from test
删除表数据和表结构: drop table test