I'm a VERY recent convertee.. (I remember when MySQL was new!) So
I _just_ read this, no genious here, but have you tried:
`LOAD DATA INFILE' syntax
=========================
LOAD DATA [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]]
[LINES TERMINATED BY '\n']
[(col_name,...)]
The `LOAD DATA INFILE' statement reads rows from a text file into a
table at a very high speed. If the `LOCAL' keyword is specified, the
file is read from the client host. If `LOCAL' is not specified, the
file must be located on the server. (`LOCAL' is available in *MySQL*
3.22.6 or later.) Using `LOCAL' will be a bit slower than letting the
server access the files directly, since the contents of the file must
travel from the client host to the server host.
[...]
"* Use of `LOAD DATA INFILE'. In many cases, this syntax is
compatible with Oracle's `LOAD DATA INFILE'"
mysqlimport just calls this function.. It's from
$DIST_DIR/docs/manual.txt about 1/2 way through.
On Wed, 13 Jan 1999, tim wrote:
> How does one run a pile of SQL code into mysql?
>
> I recall that this can be done with "start foo.sql" in SQL*plus, but how
> can I do it from (within or without) MySQL's interactive shell tool?
>
> Thanks very much. (I was too dumb to find this in the documentation,
> sorry)
pat
:)
[EMAIL PROTECTED] (key: www.title14.com/pgp/pat.key)
Programming Rates: I do it: $20 You watch: $40 You help: $80
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
