Hi everyone,
I’m looking for the proper presentation (syntax) that will use a dynamic value
from the table instead of a fixed value as given in the common example below:
SELECT date('now','+1 month’);
= 2018-09-18
I want to replace the ( “+1” ….. months) with a dynamic value from my table
fie
Thank you.
From: sqlite-users on behalf of
Richard Hipp
Sent: Tuesday, June 27, 2017 5:18:51 AM
To: SQLite mailing list
Subject: Re: [sqlite] UTF8-BOM not disregarded in CSV import
The CSV import feature of the SQLite command-line shell expects to
find UTF-8.
” commands, perhaps leeway
can be shown in breaking with standards for the sake of compatibility and
sanity?
Mahmoud
From: Clemens Ladisch
Sent: Friday, June 23, 2017 2:25 AM
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] UTF8-BOM not disregarded in CSV import
Mahmoud Al-Qudsi wrote
, this is of particular importance since the latest versions of MS Excel
default to “UTF-8 CSV” which includes a BOM. Would anyone be opposed to a patch
to SQLite that disregarded a BOM when found during a csv import operation?
Thank you kindly,
Mahmoud Al-Qudsi
NeoSmart Technologies
On 03/07/2014 08:28 PM, Muhammad Bashir Al-Noimi wrote:
Howdy,
I've two identical sqlite databases from structure side. I want to
make a synchronization for the data but I need to keep some tables
away from the synchronization process.
Is there any library can do that OR I'v
* I read about symmetricds <http://www.symmetricds.org/> but I'm not
sure what if works for the above request
--
Best Regards,
Muhammad Bashir Al-Noimi
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
son that anything should be
attempting to convert it to an integer.
The non parameterized statement works, however it fails on names that contain a
single quote ( O'Neil for example ) for obvious reasons.
Any suggestions would be appreciated.
On a related question, o
If a database file is created with 2.3.2 is it 'safe' to use with SQLITE3 3.7.x
shell?
When VACUUM is performed on 2.3.2 database file is with SQLITE 3.7.x are there
any side effects?
Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http:
Thank you,
I was wondering about adding a new constraint to an existing column that is
currently holding data.
On Sun, Oct 10, 2010 at 10:54 AM, P Kishor wrote:
> On Sun, Oct 10, 2010 at 2:45 AM, Fadhel Al-Hashim
> wrote:
> > Good day,
> >
> > is it possible to Alter
Good day,
is it possible to Alter a table and add a unique constraint on one or more
columns?
thanks,
fadhel
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
yes PRIMARY KEY (x,y,z)
On Sat, Oct 2, 2010 at 9:10 PM, Simon Slavin wrote:
>
> On 2 Oct 2010, at 1:15pm, Fadhel Al-Hashim wrote:
>
> > I did not add indices on those columns assuming that being PK is enough?
> is
> > that right?
>
> How did you define the primary
I did not add indices on those columns assuming that being PK is enough? is
that right?
On Sat, Oct 2, 2010 at 3:08 PM, Drake Wilson wrote:
> Quoth Fadhel Al-Hashim , on 2010-10-02 14:51:59 +0300:
> > tryingA.x<>B.xANDA.y<>B.y ANDA.z<>B.z w
Good day everyone.
I have two tables that contain about 5 million records. I am trying to write
an SQL command to delete rows from table A with PK (x,y,z) where PK (x,y,z)
is not in table B.
tried using "NOT IN" but my PK is composite.
tryingA.x<>B.xANDA.y<>B.y ANDA.z<>B.z
Hello again,
Does any one help me in this issue? I couldn't find any modeling tool
for SQLite on Linux?! I need a tool provides diagram database designer
just line SQLite Maestro.
Thanks in advance...
On 01/05/2010 08:14 م, M. Bashir Al-Noimi wrote:
> Hi folks,
>
> Any one kn
#x27;s
nice editor but it doesn't support diagram database designer
--
Best Regards
Muhammad Bashir Al-Noimi
My Blog:http://mbnoimi.net
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
THANKS MAN!
On Sat, Jun 27, 2009 at 10:14 AM, P Kishor wrote:
> On Sat, Jun 27, 2009 at 10:03 AM, Jamiil Abd Al Qadir
> wrote:
> > Hey kids!
> > I wanted to know if there is a tutorial of how to create new database
> > tables, sort tables, etc., etc.
> >
> .
Hey kids!
I wanted to know if there is a tutorial of how to create new database
tables, sort tables, etc., etc.
TIA
--
Happiness has many doors, and when one of them closes another opens, yet we
spent so much time looking at the one that is shut that we don't see the one
that just opened..
_
Dennis Cote <[EMAIL PROTECTED]> writes:
> Al wrote:
>>
>> I'm using sqlite to implement a fast logging system in an embbeded system.
>> For
>> mainly space but also performance reason, I need to rotate the databases.
>>
>> The database is queri
g. Instead of moving the data to a backup, could you
>> create a new table and start dumping data there? You know, in your
>> program remember the current table (DataLogX). When it comes time to
>> roll over the log "CREATE TABLE DataLog(X+1) .Just one man's
>>
Hello,
I'm using sqlite to implement a fast logging system in an embbeded system. For
mainly space but also performance reason, I need to rotate the databases.
The database is queried regularly and I need to keep at least $min rows in it.
What I plan, is inside my logging loop, to do something
c.nc sqlite3.c ; rm sqlite3.o ; gcc -c sqlite3.c ; md5sum
sqlite3.o
7da5779ac3becd4e2b1509117872cc6b sqlite3.o
/tmp> wc -l sqlite3.c
42230 sqlite3.c
-- Al
As I understand it, SQLite2 files are not compatible with SQLite3. This
poses a dilemma for me and I would guess many others on shared, virtual
webhosts.
The docs say to simply have both versions installed and copy from vers 2
to vers 3. That's OK for dedicated servers; but, most of us who u
As you suspect, it is straightforward to make a Fortran to SQLite binding.
Here's an example with Fortran 77: http://danial.org/sqlite/fortran/
I don't see why an F95 binding would need to be compiler specific. -- Al
On 4/14/07, Gary Scott <[EMAIL PROTECTED]> wrote:
Hi,
Here are SQL statements that will generate a 24 MB database
of US baseball information:
http://danial.org/sqlite/lampsig/baseball.sql.bz2
The original data came from
http://baseball1.info/statistics/lahman52_csv.zip
and the schema is explained in http://baseball1.com/statistics/readme52.txt
On 3
t2 may be faster still), different Linux kernels.
I've found a marginal (3%) performance boost by dowloading the
beta for GCC v4.1, then building SQLite (again, with all the optimization
tweaks) with it instead of GCC 3.x. But that's a lot of hassle for little
gain.-- Al
demo creates a database, inserts values into a table, then
does a query. It builds with g77 and gcc. -- Al
On 7/8/05, Cornel Gazdaru <[EMAIL PROTECTED]> wrote:
> Hi
> I am trying to figure out a wrapper to access sqlite from FORTRAN (g77
> and gcc)
> I try using "cfr
This table keeps track of how far two people ran in
a given week:
create table t(name, day, distance);
insert into t values("al", "monday" , 4.0);
insert into t values("al", "tuesday" , 4.1);
insert into t values("al", "wednesday
d lgid = "NL"));'
which tries to answer the question "which National League third
baseman had the most stolen bases in a season?" Then again,
the query could be slow because I didn't formulate it correctly. -- Al
On 5/22/05, Ludvig Strigeus <[EMAIL PROTECTED]>
On Apr 9, 2005 12:43 AM, Andy Lutomirski <[EMAIL PROTECTED]> wrote:
> Al Danial wrote:
> > The attached C program measures insert performance for populating
> > a table with an integer and three random floating point values with
> > user defined
dware
do you have? I'm especially interested in how much faster the
code runs on systems with multiple disks in a RAID 0 configuration.
Are there other tricks to speeding insert performance? Is it even
reasonable to ask for more? -- Al
/*
[EMAIL PROTECTED]
# sample build:
gcc -o sql
On Fri, 11 Mar 2005 14:29:44 -0500, Andrew Shakinovsky
<[EMAIL PROTECTED]> wrote:
> Has anyone had any luck compiling SQLite successfully on this platform?
> These are the results from the test suite (with some successful runs
> removed to preserve space).
>
> AIX 5.2 Power4+ 64 bit using xlc 7.0:
's what it returns:
/home/al> valgrind --version
valgrind-2.2.0
/home/al> valgrind /usr/local/sqlite-3.0.7/bin/sqlite3
==13527== Memcheck, a memory error detector for x86-linux.
==13527== Copyright (C) 2002-2004, and GNU GPL'd, by Julian Seward et al.
==13527== Using valgrind-2.
Just confirming that the patched code (cvs checkout this morning @ 8
AM PDT) works on the Opteron machine w/Gentoo 2004.1 amd_64 mentioned
earlier in this thread. Cool! Only two glitches left:
2 errors out of 14857 tests
Failures on these tests: printf-8.1 printf-8.2
the errors are
print
segfaulted
in one of my print statements. Weird. If anyone has debug suggestions
I'll try them.-- Al
On Tue, 7 Sep 2004 11:39:21 -0700 (PDT), Louis P. Santillan
<[EMAIL PROTECTED]> wrote:
> Do the rumors apply to 64-bit Linux or do they apply
> elsewhere? I can give you
spect the answer has to do with
it being a matter of personal choice since C++ is a superset of C?
Or am I missing something and lemon can actually produce true
OO C++ code?-- Al
eat though, and demonstrates the prepare/step/finalize method
very clearly.
It would be cool if sqlite came with an examples/ subdirectory that
contained this program (or ones like it). Examples can often explain
things so much more easily than text descriptions of functions.
-- Al
On Tue, 27 Ju
Thanks for the clarification. I'll need to study the docs on the three
part method and slowly figure it out. A working example sure would
be nice! -- Al
On Mon, 26 Jul 2004 11:21:08 +0100 (BST), Christian Smith
<[EMAIL PROTECTED]> wrote:
> Typed data retrieval is no
_SIZE][SQL_MAX_COLUMNS]; /* integer */
double x[SQL_BLOCK_SIZE][SQL_MAX_COLUMNS]; /* double */
} callback_data;
My questions:
How can I populate sql_data.i[] and sql_data.x[] without calling atoi()
and atof() on terms of azArg[]?
Is there example C code out there that demonstrates the technique?
-- Al
;
insert into A('i', 'x') values (2, 0.2);
insert into A('i', 'x') values (3, 0.3);
insert into B('i', 'y') values (1, -11.1);
insert into B('i', 'y') values (2, -22.2);
insert into B('i', 'y&#
---
1 0.1
2 0.1
3 0.1
If I work only with one table then the update works as expected:
update B set y=i;
select * from B;
i y
-- --
1 1
2 2
3 3
Is there an undocumented limitation on sqlite's update?
t v from uv,xy where xy.i = uv.i);
but it appears inefficient in that it has to do the same join twice. It
will be worse in my actual database because I'm trying to update three
columns at once. Is there a way to write the UPDATE so that the join
is done just once? I'd like to avoid
I do website design for clubs, etc., with a lot of custom, CM php scripts.
SQLite is ideally suited for many of my scripts; but, unfortunately one of
the sites is hosted on a FreeBSD based server. Most of my designs are
Linux; but, I want to keep the designs portable.
I tried to compile and insta
42 matches
Mail list logo
