You have to do two things to run SQL statements from a batch file:
1. Use quotes so that all parameters to sqlite3.exe are a single parameter; and
2. Use quotes so that SQL strings are delimited correctly.
e-mail wrote:
> sqlite3.exe -csv "C:\...\places.sqlite" "SELECT ...
> datetime(...,"unixepo
I'm pretty new at SQLite, so this may seem obvious to you. Be kind.
I'm using Python on Ubuntu Linux 16.04 LTS, and the sqlite that is built
into Python. The database
is using WAL.
I've got a database of some 100 million records, and a file of just over
300 thousand that I want represented in it
This "view" works in "DB Browser for SQLite" to get my Firefox Bookmarks . . .
I then export them to Desktop as a .CSV, and run an Excel macro on them . . .
SELECT a.id AS ID, a.title AS Title, b.url AS URL,
datetime(a.dateAdded/100,"unixepoch","localtime") AS Date
FROM moz_bookmarks AS a J
Hello, Everyone.
I'm Akira.
I found a bug.
I use sqlite3 on windows.
I figure out that odd character on CSV mode when I use Mbcs.
I understood that the columns is not converted by winUnicodeToMbcs when it's
needs quotation on csv mode in WIN32
Please see lines from 2553 to 2558 below source.
This is fixed in the current head of trunk. Although the implementation may
change, it will appear in the next release.
https://www.sqlite.org/src/timeline?n=50
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Origin
Simon, I’ve no users. I’ve been teaching myself c++ (and SQLite) during a
lengthy illness so this is just experimentation for me.
This subject touches on a previous question of mine you were involved in
regarding redundant tables. The following may jog your memory
create table TblA(A intege
On 11/25/2017 02:57 AM, Stephen F. Booth wrote:
I have been working on a custom FTS5 tokenizer using SQLite 3.21.0. I
noticed that in fts5CreateTokenizer() if the call to sqlite3_malloc() fails
SQLITE_NOMEM is returned, however xDestroy (if present) is not called. A
similar situation is handled
On 25 Nov 2017, at 1:41pm, Richard Hipp wrote:
> Web developers - help me with this: For item (3) above, how can I
> make the ellipsis or icon to "show more detail" configurable using
> CSS?
Declare two different CSS classes: one is the "hidden" one which does not show
the content, and the o
I have been working on a custom FTS5 tokenizer using SQLite 3.21.0. I
noticed that in fts5CreateTokenizer() if the call to sqlite3_malloc() fails
SQLITE_NOMEM is returned, however xDestroy (if present) is not called. A
similar situation is handled differently in sqlite3_bind_pointer(); in that
fu
>Hi, ALL,
>Right now my C Language option on the Xcode 5.1.1 is set to "GNU99".
>When using this option I am getting a lot of different warnings like:
>
>Value Conversion Issue
>Implicit conversion loses integer precision.
>
>I know its just a warning, but I prefer the code to be compiled clean.
>
Please ignore. This post was intended for
fossil-us...@lists.fossli-scm.org, not for the SQLite users mailing
list. My appologies..
On 11/25/17, Richard Hipp wrote:
> In the latest code on https://www.fossil-scm.org/fossil/timeline and
> at https://sqlite.org/srcx/timeline has a "Declutter"
In the latest code on https://www.fossil-scm.org/fossil/timeline and
at https://sqlite.org/srcx/timeline has a "Declutter" button on the
sub-menu bar to simplify the screen. In the simplified timeline,
there is a "Details" button to get all the details back again.
I'm not done with this interface
On 25 Nov 2017, at 1:15pm, curmudgeon wrote:
> Given a select where a 'base table' is attached to lookup tables
> how can I determine which of the lookup tables can be removed from the table
> such that
>
> select BaseTbl.RowID from ... where ... order by ...
>
> will find the set of records
Sorry, in last post
select * from (select Value from carray(ID+?1, ?2, 'int64'))
inner join AwfyBigTbl on AwfyBigTbl.RowID = _Value;
by setting ?1 = TopRecNo and ?2 = n.
should read
select * from (select Value from carray(*?1*, ?2, 'int64'))
inner join AwfyBigTbl on AwfyBigTbl.RowID = _Value;
A trivial example of what I'm trying to do. Given
select * from AwfyBigTbl where ACol=?;
I'd run the query
select RowID from AwfyBigTbl where ACol=?;
step through the records and store the values in a std::vector
called ID.
I could then retrieve n records starting at TopRecNo (0 based) with the
>> What about time resets to the epoch which are not restored, user time
>> changes,
>
> I know some systems at least increment the node each time a time change is
> detected. It will take 2^47 time changes to roll over. Since the node part is
> not relevant to SQLite, this is perfectly safe.
Ah, I see someone else has already brought up version 1 UUIDs.
> What about invalid and reused MAC addresses and devices with no MAC address
> at all?
Not an issue with SQLite since that part of the UUID is a constant within a
given database. It would be reasonable to simply pick "0" then set t
Are people here talking about UUIDs or things that just look like UUIDs? It
sounds like the latter. UUIDs are actually structured objects, with embedded
type bits. There are multiple UUID generation schemes, one of which is based on
random numbers, others are based on hashes, and there is the co
Dear all,
I'm looking for a mean to query the current WAL page count (at other times than
at commit through the wal_hook() callback).
Did I overlooked something in the C API which would allow me to query this?
--
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia
_
19 matches
Mail list logo