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")
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
- MySQL Reference Manual - "LOAD DATA INFILE" entry
- MySQL — Offical website
- Wikipedia article on MySQL