how to show the equivalent hex value of integer data while select in sqlite3
shell?
sqlite>
sqlite> CREATE TABLE test (id INTEGER, data INTEGER);
sqlite> INSERT INTO test VALUES (1, 32);
sqlite> SELECT * FROM test;
1|32
sqlite>
sqlite>
sqlite> SELECT hex(data) FROM test;
3332 ### hope to ge
Jeremy Zeiber wrote:
> This query runs in ~ 17 ms:
> SELECT COUNT(data) FROM detail AS outerdetail WHERE headerid=4 AND data
> NOT IN (SELECT DISTINCT data FROM detail WHERE headerid<4)
Here the subquery is not coordinated. It is run once, the results are stored in
an ephemeral table, then the ch
Jay A. Kreibich a écrit :
> On Sun, Jan 03, 2010 at 10:47:01AM +0100, Mathieu SCHROETER scratched on the
> wall:
>> Hello,
>>
>> I've a simple question about the bind functions. If it can
>> be realistic to have in the future, a way to bind a sub-query
>> in a query?
>
> Doubtful. Sub-queries
From now on, would anyone responding to this thread on sqlite-users@sqlite.org
please cross-post your on-topic responses to dbd-sql...@lists.scsys.co.uk as I
am? I moderate the dbd-sqlite list and will let your postings through even if
you aren't subscribed to it. This is to help save me some
Oh! Certainly, I didn't see it. I am using Outlook and probably I forgot to
update the messages before answering.
Well, the important is everything works.
What was lacking in my script test.sql was:
pragma foreign_keys = on;
After this, I am happy!
Thank you very much!
- Original Message --
Oh! Sorry! I didn't read Igor's message. I will read the article and
certainly I will get the result! Sorry again!
Jean and Igor, thank you!
- Original Message -
From: "Luciano de Souza"
To: "General Discussion of SQLite Database"
Sent: Sunday, January 03, 2010 4:04 PM
Subject: Re: [s
> -Ursprungligt meddelande-
> Från: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] För Luciano de Souza
> Skickat: den 3 januari 2010 19:05
> Till: General Discussion of SQLite Database
> Ämne: Re: [sqlite] Foreign key support in Sqlite
>
> I can't comprehend!
I can't comprehend! I downloaded the two packs in c:\test. Three files were
unpacked: sqlite3.exe, sqlite3.dll and sqlite3.def.
I created the database:
c:> sqlite3 test.db
I create the structure:
sqlite> .read test.sql
The test.sql contains the statements mentioned before.
I tried to insert
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Adam Kennedy wrote:
> Unfortunately, we neither have the ability to run configure (as we
> don't have reliable access to /bin/sh or any of the other stuff it
> needs) or the ability to use a pregenerated static configuration
> across all platforms.
We
Apologies, that should be...
http://svn.ali.as/cpan/trunk/DBD-SQLite/Makefile.PL
2010/1/3 Adam Kennedy :
> The build code we're using is run across all operating systems.
>
> You can see the actual build script here.
>
> http://ali.as/cpan/trunk/DBD-SQLite/Makefile.PL
>
> Unfortunately, we neithe
The build code we're using is run across all operating systems.
You can see the actual build script here.
http://ali.as/cpan/trunk/DBD-SQLite/Makefile.PL
Unfortunately, we neither have the ability to run configure (as we
don't have reliable access to /bin/sh or any of the other stuff it
needs) o
Thanks for the comments on the build flags, we will investigate.
The threadsafe disabling may be a result of DBD::SQLite being itself
compiled on a Perl that has threading compiled out (which adds about
10-20% overall speed and is used in certain situations).
Adam K
DBD::SQLite Release Manager
2
>create table cities
>(
>id integer primary key not null,
>name text not null
>);
>
>create table people
>(
>id integer primary key not null,
>name text not null,
>cities_id integer not null,
>foreign key(cities_id) references cities(id)
>);
>
>insert into cities(name) values('Campos');
>insert in
Luciano de Souza wrote:
> Everything downloaded correctly, but there is still something wrong.
http://www.sqlite.org/foreignkeys.html#fk_enable
http://www.sqlite.org/pragma.html#pragma_foreign_keys
Igor Tandetnik
___
sqlite-users mailing list
sqlite-us
Everything downloaded correctly, but there is still something wrong. Perhaps
my very short experience in SQL resulted in any statement mistake.
Let me show again how the tables are created and the data inserted:
create table cities
(
id integer primary key not null,
name text not null
);
create
Hi,
>I am trying to migrate to Sqlite3.6.21. I visited the Sqlite site and
>downloaded the compiled file. I'm surprised in verifying that the zip
>only had the executable. I hoped to find also the DLL.
I bet you downloaded this: http://www.sqlite.org/sqlite-3_6_21.zip
This is the CLI, he comma
Hello listers,
I am trying to migrate to Sqlite3.6.21. I visited the Sqlite site and
downloaded the compiled file. I'm surprised in verifying that the zip only had
the executable. I hoped to find also the DLL.
Well, since I could not find the DLL file concerning this version, I presumed
DLL do
On Sun, Jan 03, 2010 at 10:47:01AM +0100, Mathieu SCHROETER scratched on the
wall:
> Hello,
>
> I've a simple question about the bind functions. If it can
> be realistic to have in the future, a way to bind a sub-query
> in a query?
Doubtful. Sub-queries are a syntactical thing and exist beca
Hello,
I've a simple question about the bind functions. If it can
be realistic to have in the future, a way to bind a sub-query
in a query?
I create queries with a number of sub-queries which depends
of the user. Then, if all sub-queries can be prepared
independently of the main query, it sugges
On 3 Jan 2010, at 3:34am, Ervin Sebag wrote:
> No need for google-fu antics. I was able to uninstall using fnpkg -r with
> the following results:
>
> Removing file /mnt/HD_a2/ffp/lib/pkgconfig/sqlite3.pc
> Removing file /mnt/HD_a2/ffp/lib/libsqlite3.la
> Removing file /mnt/HD_a2/ffp/lib/libsqlit
20 matches
Mail list logo
