MySQL

From Christoph's Personal Wiki
Revision as of 16:10, 26 January 2006 by Christoph (Talk | contribs) (Added more info. on "LOAD DATA INFILE")

Jump to: navigation, search

MySQL is a multithreaded, multi-user, SQL (Structured Query Language) Database Management System (DBMS).

External data input

Example:

LOAD [LOCAL] DATA INFILE 'foo.txt'
INTO TABLE company
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

where [LOCAL] is optional and the following must be met:

  • If LOCAL is specified, the file is read by the client program on the client host and sent to the server. The file can be given as a full pathname to specify its exact location. If given as a relative pathname, the name is interpreted relative to the directory in which the client program was started.
  • If LOCAL is not specified, the file must be located on the server host and is read directly by the server.

External links