python连接数据库，下载MySQL在pycharm中，创建游标对象，条件查询，用python增删改查数据库

from pymysql import *
conn=connect(host='localhost',user='root',password='root',
             database='market',charset='utf8')
# 创建游标对象
try:
    cur=conn.cursor()
    print('success')
except Exception as msg:
    print(msg)

try:
    # 创建游标对象
    cur=conn.cursor()
    cur.execute('select * from user') # 执行语句
    result=cur.fetchall() # 返回查询结果集的数据，返回一个元组 元组中含元组，所有行
    for item in result:
        print('loginName: {0},userName: {1}'.format(item[1],item[2]))
    print('success')
except Exception as msg:
    print(msg)
finally:
    cur.close()
    conn.close()

try:
    cur=conn.cursor()
    insersql='''
    insert into product_category(name,parent_id,type) values('新增食品','1','1')
    '''
    cur.execute(insersql)
    conn.commit() #提交连接
    print('success')
except Exception as msg:
    print(msg.args)
finally:
    cur.close()
    conn.close()

条件查询

cur.execute('select * from user where login_name=%s',['cgn']) # 执行语句

执行函数