In Sqlite3 the .import command replaces the old COPY.
When I try to use it to import a .csv file into a table t1 in database
test.db I always get the error message
Error: no such table : t1;
Probably I've got something wrong with the syntax of the .import command:
I used
>sqlite3 test.db
It worked out with pre-compiled statements (using sqlite3_bind_int).
But I still wonder if there is a way to set integer values (dynamic values)
into DB with INSERT and UPDATE?
If you don't want to use prepared statements, I believe you can get the
effect you are after with calls to
On Wed, 19 Jan 2005 10:57:13 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> If you were to guarantee that there is only one reader and only one
> writer-- not just one process, but a single thread and only one
> sqlite3_open() against any one file-- accessing the SQLite database,
> then it
On Jan 19, 2005, at 10:43 AM, Will Leshner wrote:
Bug #301 says that, because fcntl isn't supported for remove volumes
on OS X, SQLite can't acquire a lock, which, I think, pretty much
means you can't use SQLite databases that are on AFP or SMB volumes on
OS X. What would happen if I simply made
Bug #301 says that, because fcntl isn't supported for remove volumes
on OS X, SQLite can't acquire a lock, which, I think, pretty much
means you can't use SQLite databases that are on AFP or SMB volumes on
OS X. What would happen if I simply made the calls in os.c that
acquire locks NOOPs? I
Thanks Ulrik,
It worked out with pre-compiled statements (using sqlite3_bind_int).
But I still wonder if there is a way to set integer values (dynamic values)
into DB with INSERT and UPDATE?
NK
> Hi NK,
>
> [EMAIL PROTECTED] wrote:
>
> >Hi,
> >what is the correct syntax to use for WHERE
MyGeneration is a Code Generator / OR Mapper that supports SQLite (it's
free). We are creating a new .NET architecture that will also support
SQLite (among 10 other DBMS systems) if you are interested in becoming one
of our SQLite adivsors and contributors see this site:
7 matches
Mail list logo