import pymssql
    conn = pymssql.connect(host=HOST, user=USER, password=PASSWORD,
                    database=DATABASE)
    cursor = conn.cursor()
    field_lst = [u'2017-04-09', u'U0001f381', 1.0, 0.0, 0.0, 3.0]
    placeholder = '%s,' * len(field_lst)
    query = 'INSERT INTO my_table VALUES (' + placeholder.strip(',') + ')'
    cursor.execute(query, tuple(field_lst))
    conn.commit()