python连接mysql

import pymysql  

# 创建数据库连接（方法一）
# conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='test', charset='utf8')

# 也可以使用字典进行连接参数的管理（方法二）
config = {
    'host': '127.0.0.1',
    'port': 3306,
    'user': 'root',
    'passwd': '123456',
    'db': 'test',
    'charset': 'utf8'
}
conn = pymysql.connect(**config)

# 初始化游标（创建游标）
cursor = conn.cursor()  

# 返回执行结果
# result = cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')
# result = cursor.execute('insert into user (id, name) values (%s, %s)', ['2', 'Bob'])
# result = cursor.execute("update user set name = 'Bob' where id = %s", (2))
# result = cursor.execute("delete from user where id = %s", (2))
# result=cursor.fetchmany(cursor.execute("select * from user where id = %s",(2)))

# 执行查询，并返回受影响的行数
effect_row = cursor.execute("select * from user")
# 返回所有的结果集 
result = cursor.fetchall()
# 打印
for k,v in result:
    print(k,v)
print(list(map(lambda x:x%2,range(3))))
print("{0}{0}".format("py"))
#打印查询结果  
# for r in result:
#     print(r); 
    
# 提交事务
conn.commit()
# 关闭游标
cursor.close()
# 关闭连接
conn.close()