[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: One Mysql For loads and one for query
From:       Paul DuBois <paul () mysql ! com>
Date:       2004-04-30 17:50:35
Message-ID: p06020457bcb841fc1cf9 () [192 ! 168 ! 1 ! 34]
[Download RAW message or body]

At 10:34 -0700 4/30/04, rmck wrote:
>I thought I could use mysqlimport, but I notice that the text files 
>need to be the same name as the table. My text files are named with 
>a time stamp every hour so I have 24 files that get loaded. And the 
>table name is nothing like the text files names.
>
>Is there a way to have  mysqlimport import to a table that does not 
>match the text file it is reading from??

No, but mysqlimport just generates a LOAD DATA statement.  You
can bypass mysqlimport to create a LOAD DATA statement that fits your
situation.


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]