数据库基本连接和增删改查

import pymysql
conn = pymysql.Connect(
    user = 'root',
    port = 3306,
    host = '127.0.0.1',
    password = '1234',
    database = 'test',   #库名
    charset = 'utf8',
)
cursor = conn.cursor(cursor = pymysql.cursors.DictCursor)  #设置输出格式为字典，默认为元组
# sql = 'select id,name from test1'   #表名
# cursor.execute(sql)
# data = cursor.fetchall()
# print(data)
# conn.close()


# #插入
# sql = 'insert into test1(id,name) values(%s,%s)'
# cursor.execute(sql,[4,'lz1'])
# conn.commit()


#删除
# sql = 'delete from test1 where id=1'
# cursor.execute(sql)
# conn.commit()


#改
sql = 'update test1 set name=%s where id=%s'
cursor.execute(sql,['lz3',3])
conn.commit()