用python连接数据库

import pymysql
db = pymysql.connect(host='localhost',user='root',
                     password='123456',port=3306,
                     database='mysql',charset='utf8')
cur = db.cursor()
# 使用 execute() 方法执行 SQL 查询
cur.execute("SELECT VERSION()")
# 使用 fetchone() 方法获取单条数据.
data = cur.fetchone()
print('数据库连接成功！')
# # 关闭数据库连接
# db.close()
#创建表

# try:
#     create_sqli='create table sys (id int,name varchar(30),phone int);'
#     cur.execute(create_sqli)
# except Exception as e:
#     print('创建数据表失败:',e)
# else:
#     print('创建数据表成功:')


#插入数据
# try:
#     create_sqli='insert into sys values (011,"xiaoming",122345678);'
#     cur.execute(create_sqli)
# except Exception as e:
#     print('插入数据表失败:',e)
# else:
#     db.commit()
#     print('插入数据表成功:')

#更新数据
# try:
#     update_sqli='update sys SET name="xiaohua" where name="xiaoming"'
#     cur.execute(update_sqli)
# except Exception as e:
#     print('更新数据表失败:',e)
# else:
#     db.commit()
#     print('更新数据表成功:')

#查询数据
# try:
#     select_sqli='select * from sys'
#     cur.execute(select_sqli)
#     results=cur.fetchall()
#     for row in results:
#         print(row)
# except Exception as e:
#     print('查询数据表失败:',e)
# else:
#     db.commit()
#     print('查询数据表成功:')

#删除数据
# try:
#     delete_sqli='delete from sys where name="xiaohua"'
#     cur.execute(delete_sqli)
# except Exception as e:
#     print('删除数据表失败:',e)
# else:
#     db.commit()
#     print('删除数据表成功:')