[Gllug] mysqlimport

[Barry Mitchelson]

On Tue, Jul 31, 2001 at 02:06:42PM +0100, Jackson, Harry wrote:
> Hi all
> 
> 	Why Why Why does this not work but insists on giving me the help
> output for mysqlimport (It thinks its funny)
> 
> mysqlimport -d -u root -h localhost -pblahblah  --fields-terminated-by=','
> --fields-optionally-enclosed-by='"' remedy_harry  remedy.csv
> 
> 	and this does
> 
> mysqlimport -d -u root -h localhost -pahoghill --fields-terminated-by=','
> remedy_harry  remedy.csv
> 
> 	Except that the later is a pile of poo in the table
> 	

not entirely sure what the problem is, but the text file should be the same name as the table you are importing to, is your table called 'remedy.csv' ?

barry


> 
> Regards;
> Harry Jackson.
> 
> 
>      
> 
> 
> 
> **********************************************************************
> COLT Telecommunications
> Registered in England No. 2452736
> Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
> Tel. 020 7390 3900
> 
> This message is subject to and does not create or vary any contractual
> relationship between COLT Telecommunications, its subsidiaries or 
> affiliates ("COLT") and you. Internet communications are not secure
> and therefore COLT does not accept legal responsibility for the
> contents of this message.  Any view or opinions expressed are those of
> the author. The message is intended for the addressee only and its
> contents and any attached files are strictly confidential. If you have
> received it in error, please telephone the number above. Thank you.
> 
> 
> **********************************************************************
> 
> -- 
> Gllug mailing list  -  Gllug at linux.co.uk
> http://list.ftech.net/mailman/listinfo/gllug

-- 
http://www.theshining.org

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug