Database Import Commands

MySQL

LOAD DATA LOCAL INFILE ' /importfile.csv ' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3);
http://www.modwest.com/help/kb6-253.html

-- PeteBrower - 17 Jul 2007

This topic: Main > TWikiUsers > PeteBrower > AppxRelease430 > FileAuditLogging
Topic revision: r1 - 2007-07-17 - PeteBrower
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2025 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback