Insert data in database

mail@pastecode.io avatar
unknown
python
a year ago
575 B
2
Indexable
Never
    cursor_obj = con.cursor()
    insert_statement = (
            'INSERT INTO "WELD_SAMPLES" (\
                time_start, \
                time_end, \
                environment_t, \
                motor_bearing_t, \
                spindle_bearing_t, \
                counter, \
                sdintensity, \
                times, \
                angular_velocity, \
                force, \
                displacement\
                ) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'
       )
    cursor_obj.execute(insert_statement, values_list)
    con.commit()