How,do I get off this email list?? What is it for??
Sent from my iPad
> On Dec 8, 2017, at 7:30 AM, Kees Nuyt wrote:
>
> On Thu, 7 Dec 2017 23:59:02 -0700 (MST), Durgesh
> wrote:
>
>> getting error "QSqlError("18", "Unable to bind parameters",
Is it possible that the first call to random is cached and the
cached value is being returned in subsequent calls?
-
Scott Doctor
sc...@scottdoctor.com
-
On 12/8/2017 12:09, John McKown wrote:
On Fri, Dec 8, 2017 at 12:54 PM, John Mount
On Fri, Dec 8, 2017 at 12:54 PM, John Mount wrote:
> I am seeing an issue where a random value in a sub-query gets re-generated
> each time the value is used in later queries. Below is an example query:
>
> SELECT r AS r1, r AS r2 FROM ( SELECT random() AS r FROM ( SELECT
I am seeing an issue where a random value in a sub-query gets re-generated each
time the value is used in later queries. Below is an example query:
SELECT r AS r1, r AS r2 FROM ( SELECT random() AS r FROM ( SELECT * from (
VALUES(1),(2) ) ) a ) b
One would expect r1 == r2.
---
All right,
I think I was missing a potentialy important info.
I am deleting rows as ranges.
It is up to SQLite how to do the deletation.
I am pushing ranges in a loop in the transaction.
Than the loop breaks signaling "busy" or "overwhelmed" state.
Without the transaction frame it is
Well,
coming from a strongly typed education this is too much freedom for me. -
Just kidding -
Thanks for the vital info, appreciated.
-Ursprüngliche Nachricht-
From: Keith Medcalf
Sent: Friday, December 8, 2017 7:14 PM
To: SQLite mailing list
Subject: Re: [sqlite] DateTime to
That is:
UPDATE Table
SET Datum = (StrfTime('%s', Datum) + 62135596800) * 1000
WHERE typeof(Datum) == 'text';
There is no such thing as a datatype of "bigint".
This declaration will give you a column affinity of "integer".
There is no such thing as a datatype of "DateTime".
This
Hello,
I run into a little anoyance regarding virtual table.
I have a contentless table:
CREATE VIRTUAL TABLE "OCR" using fts5 (content='',FullText)
bind with a trigger for row deletition:
CREATE TRIGGER "ART_AD" AFTER DELETE ON "ART" BEGIN INSERT INTO "OCR"
("OCR",rowid)
Bow!
that's what I call 'service' !
I was looking for a good day for this and nothing habe poped up only for the
reverse task.
You made my day!
Thank You Sir.
-Ursprüngliche Nachricht-
From: Paul Sanderson
Sent: Friday, December 8, 2017 6:16 PM
To: SQLite mailing list
Subject:
Hi Tibor
Your date format is windows ticks, i.e. 100 nano seconds intervals since
01/01/0001
You can convert it as follows
SELECT (StrfTime('%s', '2004-08-05') + 62135596800) * 1000 AS Ticks
where StrfTime('%s', '2004-08-05') is the number of seconds between the
provided date and 1/1/1970
Hi there,
I am very new to SQLite but like it sofar.
Run into something couldn’t find an answer may someone can put me in the right
direction..
Have an application uses SQLite table with a column “Datum” defined as bigint.
I have an identical table with column “Datum” as DateTime “-mm-dd”
You are correct, but i'm not using sqlite enough to know (or remember)
it also has a sqlite_master :-):-)
On 08-12-17 16:48, Donald Griggs wrote:
For windows, I think the following would work:
sqlite3 %DB% -batch "SELECT TBL_NAME FROM sqlite_master WHERE type=='table'
order by tbl_name;"
Fascinating article.
Thanks.
John Gillespie
On 4 December 2017 at 13:08, Simon Slavin wrote:
> Every so often someone asks on this list for Unicode to be handled
> properly. I did it myself. Then other people have to explain how hard
> this is. So here’s an article
For windows, I think the following would work:
sqlite3 %DB% -batch "SELECT TBL_NAME FROM sqlite_master WHERE type=='table'
order by tbl_name;" >%temp%\dump.tmp
for /f "usebackq" %%i in (`type %temp%\dump.tmp`) do sqlite3 %DB% -batch
".mode tabs" -batch "SELECT * FROM %%i "
On Thu, 7 Dec 2017 23:59:02 -0700 (MST), Durgesh
wrote:
> getting error "QSqlError("18", "Unable to bind parameters", "string or blob
> too big")" while inserting a row data of size 500MB.
>
> However insertion of 450 MB is successful.
>
> Tried define the macro
On 08-12-17 14:52, Luuk wrote:
On 08-12-17 14:13, Simon Slavin wrote:
On 8 Dec 2017, at 7:02am, Peng Yu wrote:
I'd like to dump all the tables to separate files, one table one file.
Each file should be in TSV format.
Is there a convenient way to do so in sqlite3?
On 8 Dec 2017, at 1:58pm, Peng Yu wrote:
> Could you provide the working code for bash (on Mac OS X or linux)? Thanks.
Something like this …
sqlite3 myDatabase.sqlite > myTable.tsv << EOS
.mode tabs
select * from myTable;
EOS
The first EOS must be at the very
>But these special optimizations only apply when min(), max(), and
count(*) are used in isolation. Hence, they do not work for the first
query above that uses all three functions at one.
Thanks Richard.
>(1) If you are using INTEGER PRIMARY KEY, you should *not* be using a
WITHOUT ROWID. You
Could you provide the working code for bash (on Mac OS X or linux)? Thanks.
On Fri, Dec 8, 2017 at 7:52 AM, Luuk wrote:
> On 08-12-17 14:13, Simon Slavin wrote:
>>
>>
>> On 8 Dec 2017, at 7:02am, Peng Yu wrote:
>>
>>> I'd like to dump all the tables to
On 08-12-17 14:13, Simon Slavin wrote:
On 8 Dec 2017, at 7:02am, Peng Yu wrote:
I'd like to dump all the tables to separate files, one table one file.
Each file should be in TSV format.
Is there a convenient way to do so in sqlite3?
There’s no direct output from the
On 8 Dec 2017, at 1:17pm, Simon Slavin wrote:
> helps you (and us, if you want to post it) to understand what’s happening.
Please ignore my post. Dr H explain your situation exactly.
Simon.
___
sqlite-users mailing list
Hello,
I'm trying to create a minimal SQLite3 library build and seems like the
foreign keys logic is not properly run on DELETE when building the sources
with -DSQLITE_OMIT_TRIGGER=1.
Here's the patch against amalgamation v3.21.0 sqlite.c:
--- sqlite3.c.orig 2017-12-08 14:06:04.814913000 +0100
On 8 Dec 2017, at 12:20pm, x wrote:
> I have a table with 2.4 million records. It’s a without rowid table (I don’t
> know if that’s significant) with an integer primary key (ID) and several
> secondary indexes of the form (OtherCol, ID). If I run
>
> select min(ID),
On 12/8/17, x wrote:
>
> I have a table with 2.4 million records. It’s a without rowid table (I don’t
> know if that’s significant) with an integer primary key (ID) and several
> secondary indexes of the form (OtherCol, ID). If I run
(1) If you are using INTEGER PRIMARY
On 8 Dec 2017, at 7:02am, Peng Yu wrote:
> I'd like to dump all the tables to separate files, one table one file.
> Each file should be in TSV format.
>
> Is there a convenient way to do so in sqlite3?
There’s no direct output from the SQLite library to produce TSV
I have a table with 2.4 million records. It’s a without rowid table (I don’t
know if that’s significant) with an integer primary key (ID) and several
secondary indexes of the form (OtherCol, ID). If I run
select min(ID), max(ID), count(*) from BigTbl;
It takes 0.67 secs
If I run the three
On 12/8/17, Durgesh wrote:
> I am trying to insert 500 MB of row data using Qt SQL into sqlite db.
How are you measuring the row size?
>
> Insertion is successful up to 450 MB.
>
> defined macro SQLITE_MAX_LENGTH to larger value than 500 MB, as mentioned in
>
I am trying to insert 500 MB of row data using Qt SQL into sqlite db.
Insertion is successful up to 450 MB.
defined macro SQLITE_MAX_LENGTH to larger value than 500 MB, as mentioned in
http://www.sqlite.org/limits.html
Still getting above error while insertion.
--
Sent from:
I'd like to dump all the tables to separate files, one table one file.
Each file should be in TSV format.
Is there a convenient way to do so in sqlite3?
--
Regards,
Peng
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
getting error "QSqlError("18", "Unable to bind parameters", "string or blob
too big")" while inserting a row data of size 500MB.
However insertion of 450 MB is successful.
Tried define the macro SQLITE_MAX_LENGTH with value of
SQLITE_MAX_LENGTH=20 , larger than 500MB.
pls suggest a way
30 matches
Mail list logo