query = r"""LOAD DATA LOCAL INFILE '/tmp/foo.txt' INTO TABLE foo FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (@col1,@col2,@col3) set myid=@col1,mydecimal=@col3;"""
print(query)>>>LOAD DATA LOCAL INFILE '/tmp/foo.txt' INTO TABLE foo FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (@col1,@col2,@col3) set myid=@col1,mydecimal=@col3;