Re: Use MySQL with Microsoft Office

2005-03-09 Thread Patrick Connolly
it's dependent on the OS having the Jet engine. I'd be very interested to know if anyone has done an equivalent to that in Linux. -- ___ Patrick Connolly {~._.~} _( Y )_ Good judgment comes from experience (:_~*~_:) Experience comes from bad jud

Re: LOAD DATA INFILE question...

2004-11-21 Thread Patrick Connolly
ich are the 1st, 5th,28th |> and 71st fields. |> Is there a statement to do that. |> I think it would be simpler to pre-process the file using cut with the appropriate delmiter if it's not tab-delimited already. Then import the reduced file. HTH -- ___ Patrick Con

Still can't get a response from MySQL AB

2004-09-23 Thread Patrick Connolly
between what works and what doesn't. I'd prefer not to do the correspondence through this list which already has lots of traffic. Ideas are most welcome. Thanx -- ___ Patrick Connolly {~._.~} _( Y )_ Good judgment comes from experience (:_~*~_

Re: Anyone else having trouble contacting MySQL AB?

2004-09-16 Thread Patrick Connolly
Somewhere about Mon, 13-Sep-2004 at 07:23PM +0300 (give or take), Egor Egorov wrote: |> Patrick Connolly <[EMAIL PROTECTED]> wrote: |> |> > I've been trying to contact MySQL AB using the "contact us" link. I |> > got a auto-response to the effect that I

Anyone else having trouble contacting MySQL AB?

2004-09-13 Thread Patrick Connolly
experienced similar? -- ___ Patrick Connolly {~._.~} _( Y )_ Good judgment comes from experience (:_~*~_:) Experience comes from bad judgment (_)-(_) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Getting rid of duplicates

2004-08-27 Thread Patrick Connolly
called S (dialect R) which handles matrices in a multitude of ways. Removing duplicates is straightforward in that language, but from what I know about SQL so far, it is rather complicated in MySQL. What do other people do with duplicates? TIA -- ___ Patrick Connolly {~._.~} _

Re: Errata in the Study Guide

2004-08-18 Thread Patrick Connolly
Somewhere about Tue, 10-Aug-2004 at 02:19PM +0200 (give or take), Carsten Pedersen wrote: |> Hi Patrick, |> |> On Tue, 2004-08-10 at 12:16, Patrick Connolly wrote: |> > Is this the most appropriate list to mention misprints? There doesn't |> > seem to be an i

Errata in the Study Guide

2004-08-10 Thread Patrick Connolly
Is this the most appropriate list to mention misprints? There doesn't seem to be an indication where additional suggestions are to be sent. I found something that, though not exactly incorrect, works for reasons other than what a reader might think, so it's misleading. -- ___

Specifying table with mysqlimport

2004-08-09 Thread Patrick Connolly
k.CSV; mysqlimport --fields-terminated-by=',' --ignore-lines=1 db_name Bank.CSV; done Something tells me that greater minds have a better way. -- ___ Patrick Connolly {~._.~} _( Y )_ Good judgment comes from experience (:_~*~_:) Experience comes fr

Re: LOAD DATA INFILE insists on being LOCAL

2004-08-02 Thread Patrick Connolly
Somewhere about Sun, 01-Aug-2004 at 11:31AM -0400 (give or take), Michael Stassen wrote: |> |> Patrick Connolly wrote: [...] |> > Looks to me the mysql user should have no trouble with it: |> > |> > -rw-rw-r--1 pat pat 332 Jun 28 20:42 Orders.txt |

Re: LOAD DATA INFILE insists on being LOCAL

2004-08-01 Thread Patrick Connolly
unnecessary which was another surprise to me. Is there something I'm missing here? |> |> Michael Thanks Michael. -- ___ Patrick Connolly {~._.~} _( Y )_ Good judgment comes from experience (:_~*~_:) Experience comes from bad judgment (_)-(_

LOAD DATA INFILE insists on being LOCAL

2004-07-31 Thread Patrick Connolly
re. At one stage I thought it might be an obscure hardware difficulty with this aged machine (over 5 years) because of another obscure problem I had using fetchmail from a POP server. However, I noticed that once I switched off the ISP's virus checking, that problem vanis