def sqlinsert(df, tablename):
    """输入一个df，返回插入此df的sql原生语言"""
    oo = ''
    for index, row in df.iterrows():
        o = '('
        for i in range(len(row)):
            ii = row[i]
            if i == 0:
                o = o + "'%s'" % ii + ','
            else:
                o = o + '%s' % ii + ','
        o = o.strip(',')
        o = o + ')'
        oo = oo + o + ','
    oo = oo.strip(',')
    sql = 'insert into %s values %s' % (tablename, oo)
    return sql
