Someone somwhere must have a simple Perl script which does what you want.
JS
Robert L Cochran wrote:
I create an SQL file that has contents like this:
[EMAIL PROTECTED] elections]$ cat insert_precinct.sql
BEGIN TRANSACTION;
INSERT INTO "precinct" VALUES(1, 'Community Center 15 Crescent Road', 3
Hello All,
Wouldn't it make sense to write a program that reads it in, one line
at a time, splits and inserts the data into the proper tables? Even
creating the table on the fly? That's what I'd do, a little command
line utility.
It's basically the "convert to SQL" technique you suggest where the
I create an SQL file that has contents like this:
[EMAIL PROTECTED] elections]$ cat insert_precinct.sql
BEGIN TRANSACTION;
INSERT INTO "precinct" VALUES(1, 'Community Center 15 Crescent Road', 3,
'Greenbelt', 'Maryland', 0);
INSERT INTO "precinct" VALUES(2, 'Police Station 550 Crescent Road', 6,
I have a very large CSV file with 1 rows and 100 columns.and the
file looks like the following:
"a","b","c","d",
"1","2","1","3" ,
"3","2","2","1",
..
If I use .import,It seems I have to set the variable names manually .
Is there any way to import the whole data file into SQLite quickly?
T
Hello erw2,
This is how I do it.
HRESULT hr = Compile("INSERT OR IGNORE INTO Files_V1"
"("
"FileOrder,"
"Filename,"
"Length,"
"Signature,"
"Date,"
"Topic, "
Hi all,
so I have a (not) simple question.
Is it possible to insert into blob field content of the file? How to =
manage it in C++?
Regards
WojciechW
On 12/6/2005 at 15:29 [EMAIL PROTECTED] wrote:
>
>This assertion failure inside of sqliteOsEnterMutex indicates
>that the program was probably not compiled THREADSAFE. That
>assert() statement was put there specifically to catch this
>kind of problem. (Good thing you didn't compile with -DNDE
"Henry Miller" <[EMAIL PROTECTED]> wrote:
> Greeting,
>
> I'm using sqlite 2.8.16 in a threaded programs.We have been seeing
> crashes when opening databases, and it looks like two threads are
> trying to open databases at the same time. We know that whoever
> compiled sqlite was told to defi
Greeting,
I'm using sqlite 2.8.16 in a threaded programs.We have been seeing
crashes when opening databases, and it looks like two threads are
trying to open databases at the same time. We know that whoever
compiled sqlite was told to define THREADSAFE, but we do not know if
that was done.
Christian Smith wrote:
On Fri, 2 Dec 2005, C C wrote:
On 12/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
The added risk in going from synchronous=FULL to synchronous=NORMAL
is minimal. You only run into trouble [when] you select
synchronous=OFF.
you've piqued my interest... Does sq
On Fri, 2 Dec 2005, C C wrote:
>On 12/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>> The added risk in going from synchronous=FULL to synchronous=NORMAL
>> is minimal. You only run into trouble [when] you select
>> synchronous=OFF.
>
>you've piqued my interest... Does sqlite implement MVC
11 matches
Mail list logo