pycharm更改mysql数据_pycharm 增删改查 mysql数据库

1、pycharm创建mysql数据表######################################################

import pymysql

# 创建连接

con = pymysql.connect(host="127.0.0.1", user="aa", password="2018", database="aa", port=3306)

# 创建游标对象

cur = con.cursor()

sql = """

create table wzx_test1224(

id int primary key auto_increment,

name varchar(30) not null,

address int(2)

)

"""

try:

# 执行创建表的sql

cur.execute(sql)

print("创建表成功")

except Exception as e:

print(e)

print("创建表失败")

finally:

# 关闭游标连接

cur.close()

# 关闭数据库连接

con.close()

2、pycharm插入单条mysql数据######################################################

import pymysql

# 创建连接

con = pymysql.connect(