Форум сайта python.su
Делаю запрос:
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;
engine.execute("LOAD DATA LOCAL INFILE '%s' INTO TABLE %s FIELDS TERMINATED BY '%s' LINES TERMINATED BY '%s' (%s) set %s",[file,table,fields_terminated,lines_terminated,columns,insert_columns])
Отредактировано ivanzzz (Май 25, 2016 01:35:16)
Офлайн
ivanzzztext
Делаю запрос:
Офлайн