On Sun, Aug 23, 2009 at 01:08, Itzchak Raiskin itzchak.rais...@gmail.comwrote:
Hi
I want to use SQLite in a GIS application where I create a database
containing terrain data (coordinates, height).
I would like to query this database with start and end points of a line and
get a vector with
On Mon, May 25, 2009 at 1:10 PM, João Eiras joao.ei...@gmail.com wrote:
Btw, the same happens with the command line sqlite program
$ sqlite
SQLite version 2.8.17
These pragmas didn't exist six years ago when 2.8.17 was current. The
only pragmas in that version are:
default_cache_size
On Sun, May 3, 2009 at 11:37 AM, scientist scientist
scientist92...@yahoo.com wrote:
Hi all,
My current Ubuntu version is 8.04 and it has sqlite3 3.4.2 by default. Now
I want to upgrade sqlite3 to its newest version.
I've already downloaded sqlite-amalgamation-3.6.13.tar.gz, uncompressed the
On Sun, May 3, 2009 at 12:32 PM, scientist scientist
scientist92...@yahoo.com wrote:
Thank you for your fast answer, but my problem still exists after I
followed your instructions.
Firstly I removed the default sqlite3 using sudo apt-get remove sqlite3
command.
After that I moved to the
On Sat, Feb 28, 2009 at 1:47 PM, jonwood nab...@softcircuits.com wrote:
Greetings,
I have a SQLite table that contains a DATETIME value. However, the database
does not appear to provide enough control over how that value is formatted.
For example, I'd like a two-digit year, to eliminate
On Thu, Feb 19, 2009 at 10:45 PM, His Nerdship
slgdoug...@optusnet.com.auwrote:
Thank you Thomas, that was most helpful.
I have just found the ROWID information
(http://sqlite.org/lang_createtable.html#rowid) - this is what I was
looking
for! You have to know something exists before you
and I did an SQL command dump of the string that I am passing to the D
SQLite wrapper and it is escaped. I am reclining on the idea that it is
the
D wrapper. I have to go to post this on the D wrapper newsgroup.
My understanding is that you can call C library functions from D. You
On Wed, Dec 31, 2008 at 11:36 AM, John Hawley
johnhaw...@blueyonder.co.ukwrote:
the following block of code executes 2 or 3 orders of magnitude slower
than 1 think it should ( the db was opened in earlier code)
Yup, you're committing each insert to disk (a VERY slow process) rather than
On Mon, Dec 15, 2008 at 1:43 PM, P Kishor punk.k...@gmail.com wrote:
On 12/15/08, Joanne Pham joannekp...@yahoo.com wrote:
Hi All,
I have this problem about open the database. Here is the detail about
the problem.
Our application have one process to create the database and another
On Fri, Oct 31, 2008 at 9:06 AM, yoky [EMAIL PROTECTED] wrote:
Hi all,
I create a table like this create table tbl1 (ID integer primary
key, name, addr) ,
then insert a record:
insert into tbl1 values(1, 'aa', 'bb'),
select the record:
select * from
On Sat, Sep 6, 2008 at 10:44 AM, D. Richard Hipp [EMAIL PROTECTED] wrote:
As a bonus, if the implementation of SQLite changes, SQL itself won't,
so id will _still_ be a valid integer primary key, even if the
implementation detail of rowid changes.
I promise that INTEGER PRIMARY KEY will
On Mon, Sep 1, 2008 at 10:16 PM, jonwood [EMAIL PROTECTED] wrote:
Okay, I give up. I've been searching for a while now. I've found a number
of
discussions about how CURRENT_DATE returns the date in UTC, and that it can
be converted to local time. But I've yet to find one article that clearly
On Mon, Sep 1, 2008 at 10:29 PM, Derrell Lipman
[EMAIL PROTECTED] wrote:
On Mon, Sep 1, 2008 at 10:16 PM, jonwood [EMAIL PROTECTED] wrote:
Okay, I give up. I've been searching for a while now. I've found a number
of
discussions about how CURRENT_DATE returns the date in UTC
On Tue, Aug 5, 2008 at 10:31 AM, csabi81 [EMAIL PROTECTED] wrote:
I have made the test with following results:
Useing SELECT ALL * FROM tablename WHERE... order by id; on the
original
database and
SELECT ALL * FROM tablename order by id; on the cloned database give me
the same results.
On Fri, Jul 25, 2008 at 5:23 AM, Alexey Pechnikov [EMAIL PROTECTED]
wrote:
Database servers such as Oracle or PostgreSQL have transactions log and
restore log.
Those logs are effectively duplicates of the data or ways of
reconstructing the data. SQLite has a transaction log for the
On Wed, Jun 4, 2008 at 10:01 AM, D. Richard Hipp [EMAIL PROTECTED] wrote:
Let me strongly reiterate that you look into using the new R-Tree
virtual table available for SQLite. R-Trees are specifically designed
to do exactly the kind of query you are asking to do. See
On Fri, May 2, 2008 at 11:56 AM, D. Richard Hipp [EMAIL PROTECTED] wrote:
However, as we have gained experience with the VFS, we have come to
realize that the original VFS design has some warts. In particular,
not all of the methods in the VFS interface are able to return the
errors that
On Thu, Apr 17, 2008 at 3:15 PM, Alex Katebi [EMAIL PROTECTED] wrote:
I will give a simple example:
create table t1(name);
insert into t1('Alex');
begin;
insert into t1 values ('Dennis');
select * from t1;
The above will show two rows. How can I see only the 'Dennis' row in this
simple
On Wed, Apr 2, 2008 at 10:30 AM, Wensui Liu [EMAIL PROTECTED] wrote:
good morning, all,
when i tried to use sqlite in emacs with shell mode, it doesn't work.
is there a interface for sqlite in emacs / xemacs?
I use sqlite in emacs shell mode all the time. What problem are you
encountering?
On Wed, Mar 26, 2008 at 4:14 PM, Fred J. Stephens [EMAIL PROTECTED] wrote:
Mike McGonagle wrote:
Hum, on the Mac (10.4.9), the terminal window can be cleared from within
the
terminal program itself. I would imagine that other terminal programs also
provide this. Does this functionality
On Tue, Mar 25, 2008 at 11:02 AM, Gilles Ganault [EMAIL PROTECTED] wrote:
Hello
In MySQL, I used the following to only get calls received in the last
two weeks:
WHERE calls_date DATE_SUB(CURRENT_DATE, INTERVAL 15 DAY)
Is there an equivalent in SQLite, or should I perform this
!
Derrell
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Derrell Lipman
Sent: terça-feira, 18 de março de 2008 11:26
To: General Discussion of SQLite Database
Subject: [sqlite] algorithm for adding columns to a table
I could use another set
I could use another set of eyes or three to verify that this algorithm
makes sense. I have legacy sqlite2 databases for which I need a
generic function to add columns to tables. This is the pseudocode for
the function. Am I missing anything?
In this pseudocode, the parameters are:
On Thu, Feb 28, 2008 at 11:48 AM, Lars Aronsson [EMAIL PROTECTED] wrote:
Gilles Ganault wrote:
But then, how many people use SQLite to handle 68 milions rows
in a table?
I've got 60 million in one table, and this is with an sqlite2
database. Works just fine, BTW.
Derrell
On Wed, Feb 27, 2008 at 12:34 PM, Joanne Pham [EMAIL PROTECTED] wrote:
Hi All,
I used the sqlite3_prepare_v2 in my code and some of the servers are ok
but one of my server return an error message that undefined symbol:
sqlite3_prepare_v2 when the process is started and access the
On Wed, Feb 27, 2008 at 6:23 PM, Joanne Pham [EMAIL PROTECTED] wrote:
Hi all,
Thx for the response!
On different Linux server. So how to find out what is the SQLite version on
the server which has the problem.
How to find out the sqlite version using Linux commnad.
Doing it with a Linux
On Feb 16, 2008 12:01 PM, Fred J. Stephens [EMAIL PROTECTED] wrote:
How can I issue 2 commands to SQLite at the same time in a shell script?
I want to temporarily change the separator for the returned data,
something like:
sqlite3 database.db .separator , SELECT first,last FROM address;
Frank Pool [EMAIL PROTECTED] writes:
I want to create a table with two colums:
One ist the primary key (test_num)
and the second column sholud contain the value of the primary key (maybe as
a string) by default.
How can I define this table in sql ?
CREATE TABLE test_table (test_num
Brandon Eley [EMAIL PROTECTED] writes:
Thank you for this information. How would I access the 2.8.x database from
within PHP? is it even possible?
Go to http://www.php.net. Type sqlite into the search box at the top. The
page it brings you to describes the sqlite 2.8.x interface. The PECL
Brandon Eley [EMAIL PROTECTED] writes:
No, I can't upgrade to PHP5, yet. We're on PHP4.
I was accessing sqlite 2.8.x databases with PHP4 a number of years ago. It
worked fine. The page I referred you to previously _initially_ discusses the
object interface for the sqlite functions. That,
jose isaias cabrera [EMAIL PROTECTED] writes:
C.Peachment wrote,
On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote:
Greetings!
imagine this data content,
c1, c2, c3
a, 1, 2
b, 3, 4
c, 5, 6
a, 9, 8
a, 1, 9
c, 1, 3
I would like to get a list of all the items in c1. So, the
Chris Jones [EMAIL PROTECTED] writes:
I don't think that solves my problem. Sure, it guarantees that the IDs are
unique, but not the strings.
My whole goal is to be able to create a unique identifier for each string,
in such a way that I dont have the same string listed twice, with
Chris Jones [EMAIL PROTECTED] writes:
Derrell.Lipman wrote:
Chris Jones [EMAIL PROTECTED] writes:
I don't think that your original solution solves that problem either. You
first posted this schema:
My schema looks as follows:
CREATE TABLE rawfen ( fen VARCHAR(80) );
CREATE INDEX
Mitchell Vincent [EMAIL PROTECTED] writes:
I have an old SQLite 2.8 database that shared it's schema with
PostgreSQL. One of the nifty things about PostgreSQL (that admittedly
has me spoiled) is the ability to just say varchar without any
length specifier.
Specifying varchar in SQLite works
Rich Shepard [EMAIL PROTECTED] writes:
On Fri, 9 Feb 2007, Mikey C wrote:
This might be a dumb question, but is taking a backup of a live database
simply a matter of copying the file to a backup device/drive?
Yes. It's a regular file to your OS. As a matter of fact, you can copy the
file
[EMAIL PROTECTED] writes:
(4) What syntax do you prefer?
This seems the clearest to me, of the given choices:
SELECT * FROM t1 WHERE CAST(x AS TEXT COLLATE NOCASE)='HELLO';
Derrell
-
To unsubscribe, send
Kevin Dangoor [EMAIL PROTECTED] writes:
I'm using sqlite as a temporary store for flattened report database
(generally just one table). This data is pulled out in chunks using
OFFSET and LIMIT. This particular setup is quite simple... just insert
all of the data, and then pull it out chunk by
Bill Hernandez [EMAIL PROTECTED] writes:
I tried finding a pragma command for .headers on, but didn't have any luck.
sqlite .headers on | .mode column customers | select * from customers ;
I also tried :
sqlite select * from customers ; .headers off
and that didn't work either
You're
[EMAIL PROTECTED] writes:
The prohibition against running ATTACH within transaction
first appeared in version 3.0.1. Presumably in version 3.0.0
you could ATTACH within a transaction.
The prohibition may have appeared in 3.x but attempting an ATTACH within a
transaction doesn't work with
TB [EMAIL PROTECTED] writes:
Is there a standard (or even non-standard) term that refers to the tables,
triggers, views, indexes (any others?) in a database?
The collective term for all of the definitions taken together is the schema
of the database.
Derrell
Steve Davis [EMAIL PROTECTED] writes:
It is not a web-based app, rather browser based. Many brigades do not have
net access at their stations, they might only have someone there once a
fortnight, so it isn't viable. Also this app might also be used on a
notebook at a remote location...where
Scott Hess [EMAIL PROTECTED] writes:
On 12/13/06, RB Smissaert [EMAIL PROTECTED] wrote:
Trying to find the fastest way to determine if a table has no rows.
I think this will do:
SELECT (SELECT ROWID FROM table limit 1) IS NOT NULL;
If a table has rows then the result should be 1.
What's
RB Smissaert [EMAIL PROTECTED] writes:
How would I run these 4 commands via a .bat file or via whatever means:
cd c:\test\ReadCodes
c:\test\Program\sqlite3 c:\test\ReadCodes\ReadCode.db
.output testfile.txt
select * from readcode where read_code glob 'G2*';
I haven't been tracking this
[EMAIL PROTECTED] writes:
QUESTION 1: sqlite3_prepare_v2 is the merely the working name
for the new function. What should the official name be?
Some possibilities include:
sqlite3_prepare_ex1
sqlite3_prepare_ng
sqlite3_new_prepare
sqlite3_compile
sqlite3_compile works
Lloyd [EMAIL PROTECTED] writes:
Hi,
I stored a unix epoch (32 bit integer) date in the sqlite data base. I
want to retrieve it in the readable date format. For that I use the
following query
select datetime(sdate,'unixepoch') from mytab;
It shows a formatted date, but there is some
Ever Green [EMAIL PROTECTED] writes:
I am using sqlite3_column_text16 to retrieve data.
The problem is that sqlite3_column_text16 takes the column number as
argument. This breaks my existing code if I insert new columns in the
beginning of the column list that was specified in the SELECT
Ever Green [EMAIL PROTECTED] writes:
I dont think so!
These functions would help to get the parameter names from a prepared
statement. I want to retrieve data using column headings after a
sqlite3_step.
The function I pointed you at takes the parameter name and returns its index.
I believe
[EMAIL PROTECTED] writes:
So the question: Who will be adversely effected by the new
error behavior in the sqlite command-line shell? Who is
using the sqlite command-line shell in scripts in such a
way that the script will no longer work with the new
behaviors? Do I need to change the
Lloyd Thomas [EMAIL PROTECTED] writes:
I did try number literal 10 but mad no difference. I will rebuild the
database row as an integer.
As an interim solution (prior to changing your database schema), you should be
able to use your existing schema with this query:
select ring_time from
[EMAIL PROTECTED] writes:
[EMAIL PROTECTED] wrote:
This was likely a typo. In its current state, it's accessing uninitialized
memory. It looks like it's conceivable that an incorrect nextRowid could be
later used if the uninitialized value happens to be a small integer (smaller
than
This was likely a typo. In its current state, it's accessing uninitialized
memory. It looks like it's conceivable that an incorrect nextRowid could be
later used if the uninitialized value happens to be a small integer (smaller
than pC-nextRowid) and the valid flag therefore doesn't get set to
Kurt Welgehausen [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] wrote:
Saying NOT NULL on a PRIMARY KEY is redundant, by the way.
--
D. Richard Hipp [EMAIL PROTECTED]
**kaw~/tdpsa$ sqlite3
Loading resources from /home/kaw/.sqliterc
SQLite version 3.3.7
Enter .help for instructions
Alexander Lamb [EMAIL PROTECTED] writes:
1. (*) text/plain
Well, I am afraid it didn't work.
Somehow, the legacy_file_format info is not sticky.
I did:
sqlite3
then in command mode:
PRAGMA legacy_file_format=ON;
then
ATTACH d:\mydb.db AS mydb;
In order to have done an
John Newby [EMAIL PROTECTED] writes:
Does anyone know any reason why SQLite doesnt like tables called Table or
is this a standard SQL thing?
It's a reserved word, so if you really, Really, REALLY want to create a table
of that name (you're making it confusing to read, so you really shouldn't),
andrew gatt [EMAIL PROTECTED] writes:
I'm trying to come up with an SQL statement that works under sqlite that can
return a list of rows depending if a list of ids exist. For individual
checking i'm using:
select 1 from table where id == 1;
which returns a 1 if there is a row or no rows
Bud Beacham [EMAIL PROTECTED] writes:
In the book, SQLite (version 2.x of SQLite) by Chris Newman, he writes on
page 184 that a way to test a Tcl callback function for a locked database is
to issue a BEGIN TRANSACTION in one session and run the program in another
session.
Note the book
Bijan Farhoudi [EMAIL PROTECTED] writes:
I am trying to create table and I would like to name one of the columns
order, but pysqlite does not like it. I do not want to have order__ or any
thing like that. for example the following command does not work:
cur.execute('create table foo(i
Bijan Farhoudi [EMAIL PROTECTED] writes:
A. Pagaltzis wrote:
* Bijan Farhoudi [EMAIL PROTECTED] [2006-06-25 16:35]:
Thanks for your answer but still I am getting an error message:
sqlite create table foo(i integer, [order] integer);
sqlite .sch
CREATE TABLE foo(i integer, [order] integer);
onemind [EMAIL PROTECTED] writes:
What technology would be best suited for this task? I just assumed that a
databse would be ideal, why do you say sql isn't suited for this and what
is?
Take a look at the Controllable Regex Mutilator, CRM114,
http://crm114.sourceforge.net. It has mechanisms
Manzoor Ilahi Tamimy [EMAIL PROTECTED] writes:
Here Is The Schema For these Tables.
CREATE TABLE HVH (
Field1 VARCHAR(8),IDC VARCHAR(4),
Field3 VARCHAR(2),Field4 VARCHAR(4),
Field5 VARCHAR(7),Field6 VARCHAR(8),
Field7 VARCHAR(1),Field8 FLOAT);
CREATE TABLE ITM(
IDC
Bill King [EMAIL PROTECTED] writes:
Manzoor Ilahi Tamimy wrote:
We are Using SQLite for one of our project.
The Database Size is more than 500 MB.
It contain one table and about 10 million Records.
Err, for that size, I'd recommend going something heavier, like
firebird. This is not
Jiri Hajek [EMAIL PROTECTED] writes:
1. Occasionally after running Sqlite3_step() I get SQLITE_CANTOPEN ('Unable
to open the database file') error. I found out that it can be fixed by
running the query again, i.e. again calling Sqlite3_Prepare(). So this isn't
a big issue, but still I wonder
[EMAIL PROTECTED] [EMAIL PROTECTED] writes:
I need help in generating a unique integer for the table's primary key. I am
more familiar with MS Access that has a data type called Autonum that
generates the integer. Do I need to find the last record to know what the
next number should be?
In
Anish Enos Mathew [EMAIL PROTECTED] writes:
Igor, I know that it will show error when we try to insert a value which
is already there in the database when that field is a primary key. But
I want to check it out and I don't want that number to be inserted into
the database. I was asking about
Anders Persson [EMAIL PROTECTED] writes:
I have written a wrapper around
iRes = sqlite3_get_table(db,sql,resultp,nrow,ncolumn,errmsg);
But only SELECT works not INSERT or UPDATE
any ide.. missing somting
The database file or the directory in which it is contained is read-only?
Obviously
Michael P. Soulier [EMAIL PROTECTED] writes:
Hello,
I just got a nasty surprise. I installed an sqlite 3.3.5 .dll on windows with
pysqlite2, and I used an application to create a database file. I then scp'd
the file home to my linux box where I have sqlite 3.2.2 installed, and I got
this:
Roman [EMAIL PROTECTED] writes:
I know that ALTER TABLE - ALTER COLUMN is not supported by sqlite3.
I misspelled a column name, and I am curious if there is a command to change
the name from sqlite3 interface.
A bit simplistic, but:
echo .dump | \
sqlite3 database.db | \
sed
杰 张 [EMAIL PROTECTED] writes:
1. (*) text/plain
Hi all,
I just want to get the values of a table.The result implemented is
Open OK!
segmentation fault . Why did I got this result ? The following is my code:
Just from a quick visual inspection, it appears that you need
Uma Venkataraman [EMAIL PROTECTED] writes:
Hi Jay,
Thanks for your reply. I am trying the command
select * from mytable where row_id = row_id % 5
Try this instead:
SELECT * FROM mytable WHERE ROWID % 5 = 0;
Note that if you have an integer primary key in mytable, then ROWID and your
Iulian Popescu [EMAIL PROTECTED] writes:
How can I set the pragma values - is this something that can be done at
build time or is it only possible at runtime by executing the command
(before running any SELECT statements)?
I don't have the sqlite3 source in front of me, but in sqlite2, you
Iulian Popescu [EMAIL PROTECTED] writes:
I'm doing an application port from Windows to Linux and one of the
problems I'm facing is when executing the following statement through a call
to sqlite3_exec():
SELECT mytable.'mycolumn' FROM table
The registered callback function 4th argument (a
Iulian Popescu [EMAIL PROTECTED] writes:
I checked the versions and indeed the one I'm using on Windows is 3.0.8
whether the one on Linux is 3.1.2. This being said as far as I understand
and please correct me if I'm wrong the two PRAGMA(s) are just commands you
run used to modify the
Tito Ciuro [EMAIL PROTECTED] writes:
Hello,
SQLite 3.3.4
Mac OS X Tiger 10.4.5
After ./configure and make SQLite 3.3.4, I see that some files have
disappeared:
os_test.c
os_test.h
os_unix.h
os_win.h
This results in a few undefined symbols:
sqlite3OsClose
sqlite3FileSize
[EMAIL PROTECTED] writes:
Is the DEFAULT value for a column suppose to replace
an explicit NULL value? Or does the DEFAULT value only
get used if no values for an insert is specified? What
is the correct SQL behavior?
SQLite does the latter - the DEFAULT value is only used
if no value is
Jay Sprenkle [EMAIL PROTECTED] writes:
What I think you're really asking, though, is about the rows that are NOT
returned because there are null values. To fix that, you're probably looking
for LEFT OUTER JOIN:
Huh? I thought left join and left outer join were equivalent.
SQLite version
[EMAIL PROTECTED] writes:
PostgreSQL has a much better query optimizer than SQLite.
(You can do that when you have a multi-megabyte memory footprint
budget versus 250KiB for SQLite.) In your particular case,
I would guess you could get SQLite to run as fast or faster
than PostgreSQL by
[EMAIL PROTECTED] writes:
Should I remove the tests from SQLite that prevent
triggers in one database from referring to tables in
a different database? Or should I leave things as
they are and close ticket #1689 with a remark of
works as designed.
I have had use for triggers that could
CrazyChris [EMAIL PROTECTED] writes:
Hi there,
I have a need to create a :memory: sqlite database, but save it into the
user session (PHP) but can't see a way to access the data to save. Looking
for a sqlite version of serialize() I guess.
Has anyone managed to do this? Is it even
malcom [EMAIL PROTECTED] writes:
Hello,
I have a sqlite column with a string. This string is composed by n
different lines separated by an \n character. Each line is composed by
key: value. So my final string is something like this:
key_1: value_1_bla_bla\n
key_2: value_2_bla_bla\n
key_3:
Jim C. Nasby [EMAIL PROTECTED] writes:
On Thu, Feb 09, 2006 at 09:51:44AM -0700, Dennis Cote wrote:
program). But this didn't work. So I wrote a simple print method that takes
one argument and printf it to the standard out. This works and actually
solves my problem.
There isn't a way to get
chetana bhargav [EMAIL PROTECTED] writes:
Auto increment seems to return a unsigned long long is there any way for it
to make it as 32 bit, as I am depending on this feilds to generate unique
id, and i have a constraint fot the id to be 32 bit only.
You'll have to add enough rows to the table
Clint Bailey [EMAIL PROTECTED] writes:
Can anyone point me to web sites that are powered by Sqlite? I'm curious as
to how they function as compared to a MySQL, or brand M$ powered site.
How about http://sqlite.org ?
Derrell
Dennis Cote [EMAIL PROTECTED] writes:
Derrell,
If you are using SQLite 3.3.0 or newer then you can do the same thing in a
more direct manner using a CHECK constraint.
CREATE TABLE x(i INTEGER PRIMARY KEY AUTOINCREMENT CHECK(i (132)));
Hehe. I'm using 2.8.16 for most of my work, so I
[EMAIL PROTECTED] writes:
The situation is:
i have two DBs - one in memory and one in the filesystem. I
need to fill some tables in the second DB from the fist DB.
So, how can I ATTACH DATABASE from memory?
(unfortunately ATTACH DATABASE :memory: AS mem; fails ...)
You need to ATTACH the
rahed [EMAIL PROTECTED] writes:
Joe Wilson [EMAIL PROTECTED] writes:
I've seen this same behavior when running a MinGW-compiled sqlite3.exe in
the cygwin shell. It has
something to do with the lack of flushing of information written to stdout
(until close() anyway).
If you blindly type
Michael Scharf [EMAIL PROTECTED] writes:
Jim C. Nasby wrote:
On Thu, Jan 05, 2006 at 01:39:02PM -0600, Kurt Welgehausen wrote:
create trigger EnumTrg before insert on MainTbl for each row
when (select count(*) from EnumVals where val = new.EnumCol) = 0 begin
select raise(rollback,
test mjom [EMAIL PROTECTED] writes:
create table tbl1 ( id integer primary key autoincrement, ref
integer, sts varchar(16));
insert into tbl1 (ref,sts) values (10, 'ready' );
insert into tbl1 (ref,sts) values (20, 'ready' ); insert into tbl1
(ref,sts) values (30, 'ready' );
Jim C. Nasby [EMAIL PROTECTED] writes:
On Tue, Jan 03, 2006 at 10:15:17AM -0500, [EMAIL PROTECTED] wrote:
test mjom [EMAIL PROTECTED] writes:
create table tbl1 ( id integer primary key autoincrement, ref
integer, sts varchar(16));
insert into tbl1 (ref,sts) values (10, 'ready' );
Murray @ PlanetThoughtful [EMAIL PROTECTED] writes:
I have a column defined with DEFAULT CURRENT_TIMESTAMP in an SQLite 3.2.7 db
(on WinXP SP2, if that's important). I've noticed that the value being
stored in that column is being recorded / displayed incorrectly. For
example, it's currently
[EMAIL PROTECTED] writes:
New versions of SQLite 2 and 3 are now available on the website.
http://www.sqlite.org/
These new versions contain a one-line fix to a problem that can
lead to database corruption. The problem has been in the code
for almost 4 years and has so far gone
Bogdan Ureche [EMAIL PROTECTED] writes:
I am beginning to believe that maybe I was wrong in my assumption that 'if a
table has an index, that index shows in sqlite_master'. Then my problem is
now to find another way to get index information for a table. Any
suggestions?
An index for an
Dennis Cote [EMAIL PROTECTED] writes:
Furthermore, I don't believe that most users are using an authorizer anyway
(but I could definitely be wrong about that). In that case all the authorizer
callbacks become no-ops don't they?
PHP's use of sqlite uses an authorizer callback in the original
Jay Sprenkle [EMAIL PROTECTED] writes:
If you just want 10 records with the highest modified or created time I
think this will do it:
select *
from tbl
order by max(created_on,modified_on) desc
limit 10
except that if modified_on is null, you won't get that record. This variation
Mark de Vries [EMAIL PROTECTED] writes:
But I still don't know how to do what I want to do. Perhaps I need to
explain with a litle more detail what I mean. Consider the following
table.
create table foo (
value TEXT,
date_create TEXT,
date_lch TEXT
);
Now, whenever I insert into
Will Leshner [EMAIL PROTECTED] writes:
Say I have a table defined and populated as follows:
CREATE TABLE test (a TEXT);
INSERT INTO test (a) VALUES ('hello');
INSERT INTO test (a) VALUES ('hello');
INSERT INTO test (a) VALUES ('hello');
And I perform the following query:
SELECT
Jay Sprenkle [EMAIL PROTECTED] writes:
On 7/12/05, Gotzon Astondoa [EMAIL PROTECTED] wrote:
...
struct hostent *hep;
...
hep=gethostbyname(DomainTxt);
...
strcpy(txtIP, inet_ntoa(*((struct in_addr *)hep-h_addr_list[i])));
ip =
Ben Clewett [EMAIL PROTECTED] writes:
D. Richard Hipp wrote:
MySQL and PostgreSQL will use the indexes here, and therefore return the
result considerably faster.
Really? I would be very interested to know what
query plan MySQL and PostgreSQL use in this example.
It looks like I didn't
Cornel Gazdaru [EMAIL PROTECTED] writes:
I try copying a table from a :memory: data base to a file data base, but
could not make it work.
Anybody has any suggestions?
Thanks
I tried something like:
open a data base :memory:
create table MYTABLE (...)
...
attach 'filename.db' as
Ben Clewett [EMAIL PROTECTED] writes:
Dear SQLite,
I am running a sequence of inserts:
BEGIN
INSERT INTO table ...
INSERT INTO table ...
INSERT INTO table ...
INSERT INTO table ...
INSERT INTO table ...
I am catching the 'kill -1' signal (aka CTRL-C) and executing a final query:
Edwin Knoppert [EMAIL PROTECTED] writes:
Sorry, i seem to have posted to another thread somehow..
No you misunderstood me, i'm well able to obtain the fields but it seems not
to have the fieldnames when no rows where inserted.
I think what you're looking for is PRAGMA TABLE_INFO(table_name)
1 - 100 of 175 matches
Mail list logo