LOAD DATA

See as: raw | code

terms of service | imprint

gibney.org
is powered by m1d1

LOAD DATA (Entry Nr. 132, by user 1 \| edit)


The LOAD DATA statement loads data from a textfile into a table. Here is an example how to import data into the field "email" of a table "contacts". LOAD DATA LOCAL INFILE '/some/file.txt' INTO TABLE contacts FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' (email);

Create a new entry at this position