链接 Mysql 创建 数据库和创表，增加数据

import pymysql

try:
    host="xxx"
    user="xxx"
    passwd="xxx"
    db="test01"
    port=3306
    Table_name="kaka5"

    #  连接到服务器
    db = pymysql.connect(host, user, passwd, db, port)
    # 创立游标，对数据进行操作
    cursor = db.cursor()
    # 删除已存在的同名表格
    sql1 = "DROP TABLES IF EXISTS " + Table_name
    cursor.execute(sql1)
    # 应用SQL语句创立表
    sql2 ="create table " +  Table_name + " (FIRSTNAME CHAR(20),LASTNAME CHAR(20),AGE INT,SEX CHAR(1),INCOME FLOAT)"
    # 履行上面的sql语句
    cursor.execute(sql2)
    # 创立多行数据 （已测试过了，没问题）
    sql3="insert into " + Table_name + "(FIRSTNAME, LASTNAME, AGE, SEX, INCOME) VALUES ("J", "dana", 18, "M", "100000"), ("P", "dana", 18, "M", "100000"), ("huang", "laoban", 19, "M", "9999")"
    cursor.execute(sql3)
    # 提交履行
    db.commit()
    # 关闭连接服务器
    db.close()
    print("创立完成")

except Exception as e:
    print("创立失败" + str(e))
import pym