#导入pymysql 模块 import pymysql #创建连接 主机、用户名、密码、数据库名称 conn = pymysql.connect('localhost','root','','test') #创建游标 cursor = conn.cursor() # sql查询语句 sql = "select * from user" # sql 插入语句 # sql = "insert into user(name,age) VALUES ('%s','%s')" %(name,age)

sql = "insert into user(username,sex) VALUES (%s,%s)"

# sql 修改语句 # sql = "update user set name='%s' where id=1" # sql 删除语句 # sql = "delete from employee where id=1" # 执行sql语句 ss = cursor.execute(sql) conn.commit() # 获取数据 result = cursor.fetchone() # 关闭游标 cursor.close() # 关闭数据库连接 conn.close()