创建数据表
import pymysql
db = pymysql.connect("localhost","root","","hank")
cursor = db.cursor()
cursor.execute...SEX CHAR(1),
INCOME FLOAT)"""
cursor.execute(sql)
db.close()
----
新增数据
import pymysql...db = pymysql.connect("localhost","root","","hank")
cursor = db.cursor()
sql = """INSERT INTO leo(...db = pymysql.connect("localhost","root","","hank")
cursor = db.cursor()
sql = "SELECT * FROM leo...db = pymysql.connect("localhost","root","","hank")
cursor = db.cursor()
sql = "UPDATE leo SET AGE