| List: | Commits | « Previous MessageNext Message » | |
| From: | mcbrown | Date: | December 1 2006 3:10pm |
| Subject: | svn commit - mysqldoc@docsrva: r4093 - in trunk: refman-4.1 refman-5.0 refman-5.1 | ||
| View as plain text | |||
Author: mcbrown Date: 2006-12-01 15:10:24 +0100 (Fri, 01 Dec 2006) New Revision: 4093 Log: Updating LOAD DATA INFILE (pipe issue) thanks Dan! Fixing some faulty URLs Modified: trunk/refman-4.1/connector-odbc.xml trunk/refman-4.1/installing.xml trunk/refman-4.1/mysql-cluster.xml trunk/refman-4.1/sql-syntax.xml trunk/refman-5.0/connector-odbc.xml trunk/refman-5.0/installing-cs.xml trunk/refman-5.0/mysql-cluster.xml trunk/refman-5.0/sql-syntax.xml trunk/refman-5.1/connector-odbc.xml trunk/refman-5.1/installing.xml trunk/refman-5.1/mysql-cluster.xml trunk/refman-5.1/sql-syntax.xml Modified: trunk/refman-4.1/connector-odbc.xml =================================================================== --- trunk/refman-4.1/connector-odbc.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-4.1/connector-odbc.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 703 bytes @@ -4638,7 +4638,7 @@ service packs and hotfixes. For more information on this issue, see the <ulink - url="http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.asp”">Business + url="http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.asp">Business Objects Knowledgebase</ulink> for more information. </para> </note> Modified: trunk/refman-4.1/installing.xml =================================================================== --- trunk/refman-4.1/installing.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-4.1/installing.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 682 bytes @@ -17317,7 +17317,7 @@ <listitem> <para> FSU Pthreads (at least the version at - <ulink url="ftp::/ftp.zenez.com"/>) comes linked with GNU + <ulink url="ftp://ftp.zenez.com"/>) comes linked with GNU <literal>malloc</literal>. If you encounter problems with memory usage, make sure that <filename>gmalloc.o</filename> is included in Modified: trunk/refman-4.1/mysql-cluster.xml =================================================================== --- trunk/refman-4.1/mysql-cluster.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-4.1/mysql-cluster.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 2, Lines Added: 2, Lines Deleted: 2; 1124 bytes @@ -138,7 +138,7 @@ For exact levels of support available for MySQL Cluster on specific combinations of operating system versions, operating system distributions, and hardware platforms, please refer to the - <ulink url="http://www.mysql.com/support/clusterplatforms.html">Cluster + <ulink url="http://www.mysql.com/support/supportedplatforms/cluster.html">Cluster Supported Platforms list</ulink> maintained by the MySQL Support Team on the MySQL AB Web site. </para> @@ -445,7 +445,7 @@ node is the <command>ndb_restore</command> utility that is used to restore a cluster backup. It is possible to write such applications using the - <ulink url="&base-url-docs;/en/ndbapi/">NDB API</ulink>. + <ulink url="&base-url-docs;/ndbapi/en/index.html">NDB API</ulink>. </para> </listitem> Modified: trunk/refman-4.1/sql-syntax.xml =================================================================== --- trunk/refman-4.1/sql-syntax.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-4.1/sql-syntax.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 1, Lines Added: 10, Lines Deleted: 1; 1047 bytes @@ -5219,11 +5219,20 @@ <programlisting> mkfifo /mysql/db/x/x chmod 666 /mysql/db/x/x -find / -ls > /mysql/db/x/x +find / -ls > /mysql/db/x/x & mysql -e "LOAD DATA INFILE 'x' INTO TABLE x" x </programlisting> <para> + Note that you must run the command that generates the data to be + loaded and the <command>mysql</command> commands either on + separate terminals, or run the data generation process in the + background (as shown in the above example). If you do not do + this, the pipe will block until data is read by the + <command>mysql</command> process. + </para> + + <para> If you are using a version of MySQL older than 3.23.25, you can use this technique only with <literal>LOAD DATA LOCAL INFILE</literal>. Modified: trunk/refman-5.0/connector-odbc.xml =================================================================== --- trunk/refman-5.0/connector-odbc.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-5.0/connector-odbc.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 703 bytes @@ -4638,7 +4638,7 @@ service packs and hotfixes. For more information on this issue, see the <ulink - url="http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.asp”">Business + url="http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.asp">Business Objects Knowledgebase</ulink> for more information. </para> </note> Modified: trunk/refman-5.0/installing-cs.xml =================================================================== --- trunk/refman-5.0/installing-cs.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-5.0/installing-cs.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 691 bytes @@ -15966,7 +15966,7 @@ <listitem> <para> FSU Pthreads (at least the version at - <ulink url="ftp::/ftp.zenez.com"/>) comes linked with GNU + <ulink url="ftp://ftp.zenez.com"/>) comes linked with GNU <literal>malloc</literal>. If you encounter problems with memory usage, make sure that <filename>gmalloc.o</filename> is included in Modified: trunk/refman-5.0/mysql-cluster.xml =================================================================== --- trunk/refman-5.0/mysql-cluster.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-5.0/mysql-cluster.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 2, Lines Added: 2, Lines Deleted: 2; 1124 bytes @@ -138,7 +138,7 @@ For exact levels of support available for MySQL Cluster on specific combinations of operating system versions, operating system distributions, and hardware platforms, please refer to the - <ulink url="http://www.mysql.com/support/clusterplatforms.html">Cluster + <ulink url="http://www.mysql.com/support/supportedplatforms/cluster.html">Cluster Supported Platforms list</ulink> maintained by the MySQL Support Team on the MySQL AB Web site. </para> @@ -445,7 +445,7 @@ node is the <command>ndb_restore</command> utility that is used to restore a cluster backup. It is possible to write such applications using the - <ulink url="&base-url-docs;/en/ndbapi/">NDB API</ulink>. + <ulink url="&base-url-docs;/ndbapi/en/index.html">NDB API</ulink>. </para> </listitem> Modified: trunk/refman-5.0/sql-syntax.xml =================================================================== --- trunk/refman-5.0/sql-syntax.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-5.0/sql-syntax.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 1, Lines Added: 10, Lines Deleted: 1; 1063 bytes @@ -5159,11 +5159,20 @@ <programlisting> mkfifo /mysql/db/x/x chmod 666 /mysql/db/x/x -find / -ls > /mysql/db/x/x +find / -ls > /mysql/db/x/x & mysql -e "LOAD DATA INFILE 'x' INTO TABLE x" x </programlisting> <para> + Note that you must run the command that generates the data to be + loaded and the <command>mysql</command> commands either on + separate terminals, or run the data generation process in the + background (as shown in the above example). If you do not do + this, the pipe will block until data is read by the + <command>mysql</command> process. + </para> + + <para> The <literal>REPLACE</literal> and <literal>IGNORE</literal> keywords control handling of input rows that duplicate existing rows on unique key values: Modified: trunk/refman-5.1/connector-odbc.xml =================================================================== --- trunk/refman-5.1/connector-odbc.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-5.1/connector-odbc.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 737 bytes @@ -4639,7 +4639,7 @@ to the latest version, including any outstanding service packs and hotfixes. For more information on this issue, see the <ulink - url="http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.asp”">Business + url="http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.asp">Business) Objects Knowledgebase</ulink> for more information. </para> </note> Modified: trunk/refman-5.1/installing.xml =================================================================== --- trunk/refman-5.1/installing.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-5.1/installing.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 682 bytes @@ -15950,7 +15950,7 @@ <listitem> <para> FSU Pthreads (at least the version at - <ulink url="ftp::/ftp.zenez.com"/>) comes linked with GNU + <ulink url="ftp://ftp.zenez.com"/>) comes linked with GNU <literal>malloc</literal>. If you encounter problems with memory usage, make sure that <filename>gmalloc.o</filename> is included in Modified: trunk/refman-5.1/mysql-cluster.xml =================================================================== --- trunk/refman-5.1/mysql-cluster.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-5.1/mysql-cluster.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 2, Lines Added: 2, Lines Deleted: 2; 1124 bytes @@ -138,7 +138,7 @@ For exact levels of support available for MySQL Cluster on specific combinations of operating system versions, operating system distributions, and hardware platforms, please refer to the - <ulink url="http://www.mysql.com/support/clusterplatforms.html">Cluster + <ulink url="http://www.mysql.com/support/supportedplatforms/cluster.html">Cluster Supported Platforms list</ulink> maintained by the MySQL Support Team on the MySQL AB Web site. </para> @@ -445,7 +445,7 @@ node is the <command>ndb_restore</command> utility that is used to restore a cluster backup. It is possible to write such applications using the - <ulink url="&base-url-docs;/en/ndbapi/">NDB API</ulink>. + <ulink url="&base-url-docs;/ndbapi/en/index.html">NDB API</ulink>. </para> </listitem> Modified: trunk/refman-5.1/sql-syntax.xml =================================================================== --- trunk/refman-5.1/sql-syntax.xml 2006-12-01 13:49:58 UTC (rev 4092) +++ trunk/refman-5.1/sql-syntax.xml 2006-12-01 14:10:24 UTC (rev 4093) Changed blocks: 1, Lines Added: 10, Lines Deleted: 1; 1063 bytes @@ -6576,11 +6576,20 @@ <programlisting> mkfifo /mysql/db/x/x chmod 666 /mysql/db/x/x -find / -ls > /mysql/db/x/x +find / -ls > /mysql/db/x/x & mysql -e "LOAD DATA INFILE 'x' INTO TABLE x" x </programlisting> <para> + Note that you must run the command that generates the data to be + loaded and the <command>mysql</command> commands either on + separate terminals, or run the data generation process in the + background (as shown in the above example). If you do not do + this, the pipe will block until data is read by the + <command>mysql</command> process. + </para> + + <para> The <literal>REPLACE</literal> and <literal>IGNORE</literal> keywords control handling of input rows that duplicate existing rows on unique key values:
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r4093 - in trunk: refman-4.1 refman-5.0 refman-5.1 | mcbrown | 1 Dec |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.470 sec. using MySQL 5.1.14-beta-log