Difference between revisions of "MySQL"

Revision as of 16:10, 26 January 2006

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

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.

@@ Line 5: / Line 5: @@
 Example:
 <pre>
-LOAD LOCAL DATA INFILE 'foo.txt'
+LOAD [LOCAL] DATA INFILE 'foo.txt'
 INTO TABLE company
 FIELDS TERMINATED BY ','
@@ Line 11: / Line 11: @@
 LINES TERMINATED BY '\n';
 </pre>
+where <tt>[LOCAL]</tt> is optional and the following must be met:
+* If <tt>LOCAL</tt> 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 <tt>LOCAL</tt> is not specified, the file must be located on the server host and is read directly by the server.
 == External links ==
+* [http://dev.mysql.com/doc/refman/5.0/en/load-data.html MySQL Reference Manual - "LOAD DATA INFILE" entry]
 * [http://www.mysql.com/ MySQL] &mdash; Offical website
 * [http://en.wikipedia.org/wiki/Mysql Wikipedia article on '''MySQL''']
 [[Category:Technical and Specialized Skills]]