Duuh. The trailing ";" needs a space, otherwise the .import command thinks
";" is part of the table name. Probably not a valid character for a table
name anyway, so I guess that goes under the category "unwanted features".
Cheers
Balthasar T. Indermuehle
UNSW
Antarctic Astrophysics Group
>
Hi all,
I'm trying to import a rather large file with the .import command into a
version 3 sqlite DB file. I have created the table named data, all fields
are numeric, I type ".import data.csv data" and I get the sqlite3 error
"Error: No such table: data;"
Any ideas anyone?
thanks
I walked right into that one.
Does SQLite have a debug function to dump its parse tree
in readable ASCII form?
--- [EMAIL PROTECTED] wrote:
> We await your patch.
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
__
Do You Yahoo!?
Tired of spam?
Joe Wilson <[EMAIL PROTECTED]> wrote:
>
> I would think it would not be too difficult to extend SQLite
> to perform this type of transformation on a view.
>
> i.e., transform:
>
> SELECT columns0 from (
>SELECT columns1 WHERE condition1
>UNION (ALL)
>SELECT columns2 WHERE
The plain SELECT and the SELECT on a view below are not coded
the same way. You are making an optimization in the plain
SELECT that SQLite does not currently perform, namely
constraining the two SELECTs seperately _before_ the UNION.
The code generated by SQLite on the select on a view acts
Hi,all
Do I have to install sqlite odbc driver if I want to use ASP to connect
SQLite? If there are any available samples ,could you give me some? Thank you
so much!
-
雅虎1G免费邮箱百分百防垃圾信
雅虎助手-搜索、杀毒、防骚扰
use DBI;
$dbh = DBI->connect("dbi:SQLite:dbname=mydb.db","","", {AutoCommit=>0,
RaiseError=>1, ShowErrorStatement=>1});
eval {$dbh->do("insert into mytable (mycolumn) values ('my data')") };
if ($@) {
if ($@ =~ m/database is locked/i) {
print "db is locked\n\n$@";
} else {
Alexander Roston <[EMAIL PROTECTED]> wrote:
> I've got a small memory
> leak - each time the server accepts a request and adds
> the information to the database, it grabs 3-500 bytes
> of memory and doesn't let it go. I'd like to tell
> sqlite3_release_memory to drop the appropriate amount
> of
--- [EMAIL PROTECTED] wrote:
> You'll need to manually construct your makefile -
> the
> configure script will not do this. You can either
> edit
> the Makefile that configure generates or write your
> own using Makefile.linux-gcc as a template.
>
> The SQLITE_ENABLE_MEMORY_MANAGEMENT feature is
Alexander Roston wrote:
> I asked the compiler to show me a list of the library
routines and "sqlite3_release_memory" was not present.
shouldn't that give you a link error rather
than a segfault? Guessing that if your program
linked properly the linker found the function
somewhere. Maybe
"Iulian Popescu" <[EMAIL PROTECTED]> wrote:
>
> I have the following scenario that fails on Linux and executes fine on
> Windows XP. Suppose the following SQL statement is executed by calling
> sqlite3_exec:
>
> SELECT mySqlFunction()
>
> Inside the body of the mySqlFuntion() the following
Perfect! It works fine now... :-)
Many thanks,
-- Tito
On 20/03/2006, at 12:23, [EMAIL PROTECTED] wrote:
Tito Ciuro <[EMAIL PROTECTED]> wrote:
Hello,
I'm trying to INSERT many records using sqlite3_bind_text(). This is
what I do:
// Finish...
result = sqlite3_finalize(statement);
What
Hello,
I have the following scenario that fails on Linux and executes fine on
Windows XP. Suppose the following SQL statement is executed by calling
sqlite3_exec:
SELECT mySqlFunction()
Inside the body of the mySqlFuntion() the following statement is executed
through a call to
Tito Ciuro <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm trying to INSERT many records using sqlite3_bind_text(). This is
> what I do:
>
>
> // Finish...
> result = sqlite3_finalize(statement);
>
> What am I missing?
>
Use sqlite3_reset() if you intent to reuse the statement.
Hello,
I'm trying to INSERT many records using sqlite3_bind_text(). This is
what I do:
sqlite3_stmt *statement = NULL;
const char *sql = "INSERT INTO mytable(foo, bar) VALUES (?,?);"
int result = sqlite3_prepare(sqliteDatabase, sql, -1, , NULL);
// Do a bunch of binds and execute...
for (i
Alexander Roston <[EMAIL PROTECTED]> wrote:
> I'm having trouble with the library routine
> "sqlite3_release_memory." When I try to use it, the
> program exits with a segmentation fault.
>
> I asked the compiler to show me a list of the library
> routines and "sqlite3_release_memory" was not
I'm having trouble with the library routine
"sqlite3_release_memory." When I try to use it, the
program exits with a segmentation fault.
I asked the compiler to show me a list of the library
routines and "sqlite3_release_memory" was not present.
>From this I concluded that the
On Monday 20 March 2006 11:47, [EMAIL PROTECTED] wrote:
> BTW: Lots of people have multiple processes writing to the same
> SQLite database without problems - the SQLite website is a good
> example. I do not know what you are doing wrong to get the
> locking problems you are experiencing.
I
On Thu, 16 Mar 2006 [EMAIL PROTECTED] wrote:
>Sorry it took me some time to get back to this thread.
No problem. I missed your reply anyway:)
>
>- Original Message
>From: Christian Smith <[EMAIL PROTECTED]>
>
>> When your database does not fit in memory, yes, you're right, the OS may
On 20 Mar 2006, at 16:34, Ian M. Jones wrote:
Here's a super stripped down db and test sql scripts that still
show the problem:
http://www.ianmjones.net/wp-content/stuff/NoOuter.zip
Thanks to [EMAIL PROTECTED] the solution has been found.
I've updated the zip file with an extra
On 3/20/06, Ian M. Jones <[EMAIL PROTECTED]> wrote:
>
> On 20 Mar 2006, at 16:06, [EMAIL PROTECTED] wrote:
> >
> > Perhaps you mean something more like this:
> >
> >select xcat.Category, xc.CaseID as NumCases
> >from Cateogry AS xcat
> >left outer join Cases as xc on xcat.CategoryID =
On 20 Mar 2006, at 16:06, [EMAIL PROTECTED] wrote:
Perhaps you mean something more like this:
select xcat.Category, xc.CaseID as NumCases
from Cateogry AS xcat
left outer join Cases as xc on xcat.CategoryID = xc.CategoryID
where xc.CaseID in (3145) OR xc.CaseID IS NULL;
Or
On 20 Mar 2006, at 15:46, Jay Sprenkle wrote:
That's exactly how I did mine. I wrote 'left join' but I don't
think that makes
any difference. Perhaps if you made your database downloadable we
might be able to find out what's going on.
Hi Jay,
Here's a super stripped down db and test sql
"Ian M. Jones" <[EMAIL PROTECTED]> wrote:
>
> select xcat.Category, xc.CaseID as NumCases
> from Category As xcat
> left outer join Cases as xc on xcat.CategoryID = xc.CategoryID
> where xc.CaseID in (3145)
> ;
>
Perhaps you mean something more like this:
select xcat.Category, xc.CaseID as
> Even if I strip it down further and take out the "in", I still only
> get the one Category back when I'd expect all three:
>
> select xcat.Category
> from Category As xcat
> left outer join Cases as xc on xcat.CategoryID = xc.CategoryID
> where xc.CaseID = 3145
> ;
>
> Is there another way of
On 20 Mar 2006, at 15:17, Jay Sprenkle wrote:
On 3/20/06, Ian M. Jones <[EMAIL PROTECTED]> wrote:
select xcat.Category, count(xc.CaseID) as NumCases
from Category as xcat
left join Cases as xc on xcat.CategoryID = xc.CategoryID
where xc.CaseID in (3145)
group by xcat.Category
order by
On 20 Mar 2006, at 15:14, Igor Tandetnik wrote:
Ian M. Jones wrote:
I'm trying to get a count of all Cases for each Category, with an
outer join to Cases so that I always get a record for each Category
regardless of whether there are any Cases with that Category or not.
select
On 3/20/06, Ian M. Jones <[EMAIL PROTECTED]> wrote:
> select xcat.Category, count(xc.CaseID) as NumCases
> from Category as xcat
> left join Cases as xc on xcat.CategoryID = xc.CategoryID
> where xc.CaseID in (3145)
> group by xcat.Category
> order by xcat.Category
Is your group by summarizing
Hi guys and gals,
I'm either going mad or having a very bad day, but the following
isn't doing what I'd expect and could do with some kind soul putting
me right.
I have a table called Category which has a primary key column called
CategoryID, and three values in the Category column,
> On 3/18/06, Daniel Franke <[EMAIL PROTECTED]> wrote:
> > At Thursday I wrote:
> > > Since there's so much interest in this, I'll submit a couple of timings
> > > as soon as possible =)
On Monday 20 March 2006 15:27, Jay Sprenkle wrote:
> Thanks for posting those!
> Is that good enough
Hello Roger,
Monday, March 20, 2006, 5:19:53 AM, you wrote:
RG> Hi,
RG> I'm writing an application that writes to SQLite at least once per
RG> second. Is it wise to close the connection between each SQL call or is
RG> it better to leave the connection open while the program is running?
RG> This
Thanks for posting those!
Is that good enough performance for you?
On 3/18/06, Daniel Franke <[EMAIL PROTECTED]> wrote:
>
> At Thursday I wrote:
> > Since there's so much interest in this, I'll submit a couple of timings as
> > soon as possible =)
Don't forget the date functions work on GMT not localtime.
date('now', 'localtime'); gets your local time
What i normally do in this scenario is just a simple
httpd service restart.
That normally does the trick because i am building an application also
with PHP/Sqlite.
On Mon, 2006-03-20 at 06:47 -0500, [EMAIL PROTECTED] wrote:
> Mark Robson <[EMAIL PROTECTED]> wrote:
> >
> > If the answer is
Mark Robson <[EMAIL PROTECTED]> wrote:
>
> If the answer is "nothing", I'm going straight over to MySQL :)
>
The advantages of SQLite are that there are no administrative
hassles - there is nothing to set up or configure and the
database is contained in a single disk file that you can copy
to a
Hi all, hopefully not too long a question...
I needs records from 2 tables and in one I need the record with the maximum
ID. (to retrieve the record of the most recent version)
On other dbms I would do something like this (see below), but I think the
correlation is not available unless I have
"Roger Gullhaug" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm writing an application that writes to SQLite at least once per
> second. Is it wise to close the connection between each SQL call or is
> it better to leave the connection open while the program is running?
> This is a server application
Roger Gullhaug wrote:
Hi,
I'm writing an application that writes to SQLite at least once per
second. Is it wise to close the connection between each SQL call or is
it better to leave the connection open while the program is running?
This is a server application that will run for days and
杰 张 wrote:
> Hi,all
> I created a DATETIME field in a table. So how do it automatically INSERT
> INTO datetime data to the DATETIME field? Thank you so much!
>
>
> zhangjie
>
>
> -
> 雅虎1G免费邮箱百分百防垃圾信
If you have a DATETIME field as an
Hi,
i disagree. As far as i understand sqlite, if you sqlite3_finalize()
your statement and close your transaction, there is no reason why the
connection can not remain open. It will not hinder any reading processes.
Martin
Chethana, Rao (IE10) schrieb:
I think its better to close, since
Hi,
I'm writing an application that writes to SQLite at least once per
second. Is it wise to close the connection between each SQL call or is
it better to leave the connection open while the program is running?
This is a server application that will run for days and hopefully weeks
and months...
Hi,all
I created a DATETIME field in a table. So how do it automatically INSERT INTO
datetime data to the DATETIME field? Thank you so much!
zhangjie
-
雅虎1G免费邮箱百分百防垃圾信
42 matches
Mail list logo