upload_data_to_mysql.py 文件源码

def creat_sql_file(sql_string,dataset_name):
    conn = ( pymysql.connect(host = '114.34.138.146',# SQL IP
                             port = 3306,
                             user='guest',# ??
                             password='123',# ??
                             database='guest_dataset',  # ?????
                             charset="utf8") )   #  ??           
    c=conn.cursor()
    c.execute( sql_string )# ???? SQL file
    # ? PRIMARY KEY 
    c.execute('ALTER TABLE `'+dataset_name+'` ADD id BIGINT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY;')
    c.close() # ??? SQL ???
    conn.close()# ??? SQL ???