Thank you, thank you, thank you.
- Original Message -
From: "Jim Morris"
To: sqlite-users@sqlite.org
Sent: Thursday, March 10, 2011 2:40:34 PM
Subject: Re: [sqlite] .import FILE TABLE
.separator ","
.import myPath/myCSVfile myTable
We use a "import" file with these commands.
Thank you all,
Learning is such a joy when people are helpful :)
Eugene
2011/3/11 Teg
> Hello Eugene,
>
> How about initally attempting the fetch and if that fails, do the
> insert? Since the results of a duplicate means you want the two
> additional blobs anyway.
>
> Select so and so
>
> on e
Hello Eugene,
How about initally attempting the fetch and if that fails, do the
insert? Since the results of a duplicate means you want the two
additional blobs anyway.
Select so and so
on empty results
Insert so and so.
C
Friday, March 11, 2011, 9:15:14 AM, you wrote:
EN> Hello
EN> I am j
On 11 Mar 2011, at 2:26pm, Igor Tandetnik wrote:
> Eugene N wrote:
>> The problem is, i dont know how to *DETECT* a collision gracefully.
>
> You try to insert, and it fails with SQLITE_CONSTRAINT error.
>
>> I first thought of looking at an error code, but i am not sure its a good
>> idea.
>
Eugene N wrote:
> The problem is, i dont know how to *DETECT* a collision gracefully.
You try to insert, and it fails with SQLITE_CONSTRAINT error.
> I first thought of looking at an error code, but i am not sure its a good
> idea.
What are error codes for, in your opinion?
--
Igor Tandetnik
Hello
I am just beginning my thorn-ridden way up the steep slope with SQLite and
C++ to keep me company. And i am stuck at one point, so if you could help me
to continue it would be awsome.
I have a database contaning a table with a layout like this:
NAME PART1 PART2
blobblob blo
LinkedIn
Nguyen Chinh requested to add you as a connection on LinkedIn:
--
Zarko,
I'd like to add you to my professional network on LinkedIn.
- Nguyen
Accept invitation from Nguyen Chinh
http://www.linkedin.com/e/-62mihx-gl4ugys7-2y/BuxMMT0h2n
7 matches
Mail list logo