Very useful feature of mysql: CREATE TEMPORARY TABLE table1(id int); LOAD DATA LOCAL INFILE '/dir/file' INTO TABLE table1 Share this:Click to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window) Related