Re: [GENERAL] COPY command with blank incoming values
Re: [GENERAL] COPY command with blank incoming values
- Subject: Re: [GENERAL] COPY command with blank incoming values
- From: Jerry LeVan <email@hidden>
- Date: Fri, 2 Jul 2004 17:43:07 -0400
Doh,
Sorry about this wrong discussion group
Jerry
On Jul 2, 2004, at 4:53 PM, email@hidden wrote:
Message: 5
Date: Fri, 02 Jul 2004 08:12:50 -0400
From: Jerry LeVan <email@hidden>
To: cocoa Dev Dev <email@hidden>
Subject: Re: [GENERAL] COPY command with blank incoming values
Here is what I use:
-- /Users/jerry/Library/BiggerSQL/CopyChecks.sql
copy checks from '/Users/jerry/Quicken/QuickenData.csv' delimiter '|'
null ''
select sum(amount) from checks
_______________________________________________
cocoa-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/cocoa-dev
Do not post admin requests to the list. They will be ignored.