Re: Newbie question - Input limitations on mysql client?

[Ted Byrne]

As I mentioned in my post, I did wind up using a perl script, and I will 
continue down that path in the future.  I was mainly wondering about limits 
to the mysql client for quick-n-dirty testing (as someone who is learning 
MySQL, as opposed to developing for a production environment).

Thanks for pointing out the mysqlimport tool - that sounds like what I 
should really be using instead of cut-n-paste...

Ted
At 08:08 PM 9/29/2004, Andrew Kreps wrote:
On Wed, 29 Sep 2004 10:05:29 -0400, Ted Byrne <[EMAIL PROTECTED]> wrote:
>
> Is the apparent line length limit a restriction imposed by the client? (And
> does it apply if you are piping or redirecting output from another process
> or a file?)
>
It sounds like you should either be using a scripting language (like
Perl or PHP), or using the command line tool mysqlimport or LOAD DATA
INFILE from the mysql client.  Any of those methods should allow you
to insert long rows.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]