On 31 Mar 2010, at 6:39pm, Kevin M. wrote:
>>> So, is there an API or query I can run to load an sql file all in one go
>>> (one transaction) without having to read in the file manually and query one
>>> line at a time?
>
>> No, sorry. That's what programming languages are for. Open the
>> Actually I was wanting to put that into a program.
> I don't know how I guessed that but I'm feeling really smug now.
I'm feeling very amused by your smugness ;-)
>> So, is there an API or query I can run to load an sql file all in one go
>> (one transaction) without having to read in the
On 31 Mar 2010, at 4:48pm, Kevin M. wrote:
>> Warning: From your phrasing it's possible you're thinking of putting a
>> '.read' command into your program. The '.read' command is only a command to
>> the command-line tool. It's not a function of SQLite, and you can't submit
>> it as a query
> Warning: From your phrasing it's possible you're thinking of putting a
> '.read' command into your program. The '.read' command is only a command to
> the command-line tool. It's not a function of SQLite, and you can't submit
> it as a query in your program.
> Simon.
Actually I was
On 31 Mar 2010, at 4:21pm, Kevin M. wrote:
> Hopefully I'm not duplicating a question, but I looked on sqlite.org and did
> not find the answer...
>
> Will this:
> BEGIN TRANSACTION;
> .read somefile.sql
> END TRANSACTION;
>
> Put everything in the sql file into one transaction? Or do I need
Hopefully I'm not duplicating a question, but I looked on sqlite.org and did
not find the answer...
Will this:
BEGIN TRANSACTION;
.read somefile.sql
END TRANSACTION;
Put everything in the sql file into one transaction? Or do I need to put the
BEGIN/END TRANSACTION statements in the sql file
6 matches
Mail list logo