Dear Igor Tandetnik
Thank you for teaching me how to query data duplicatee more than 2
from table.
It is really helpful to me.
Best Regards
tom
2012/7/30 <sqlite-users-requ...@sqlite.org>
> Send sqlite-users mailing list submissions to
> sqlite-users@sqlite.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> or, via email, send a message with subject or body 'help' to
> sqlite-users-requ...@sqlite.org
>
> You can reach the person managing the list at
> sqlite-users-ow...@sqlite.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of sqlite-users digest..."
>
>
> Today's Topics:
>
> 1. Could anyone recommend books for SQLite (???)
> 2. How to query data in table more than 2? (???)
> 3. Re: Could anyone recommend books for SQLite (Peter Aronson)
> 4. Re: How to query data in table more than 2? (Igor Tandetnik)
> 5. Re: MIN() for a timedelta? (C M)
> 6. Re: Handling concurrent read request to SQLite (Navaneeth.K.N)
> 7. Unknown module FTS4 (Navaneeth.K.N)
> 8. how to process password (yanhong.ye)
> 9. open database on Linux. Already db created on Mac. (Durga D)
> 10. Re: EXT : Unknown module FTS4 (Black, Michael (IS))
> 11. Re: EXT : open database on Linux. Already db created on Mac.
> (Black, Michael (IS))
> 12. Re: how to process password (Robert Myers)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 29 Jul 2012 09:44:56 +0800
> From: ??? <huangchen...@gmail.com>
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Could anyone recommend books for SQLite
> Message-ID:
> <
> cad70eapwdpr6m0ohzscbgxfg-gded_kojvaq+oeapsufv56...@mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Dear all
> I am looking for a book ,which include all instructures and functions
> of SQLite. It is like reference guide.
> Could any help?
> your sincerely
> tom
>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 29 Jul 2012 09:50:03 +0800
> From: ??? <huangchen...@gmail.com>
> To: sqlite-users@sqlite.org
> Subject: [sqlite] How to query data in table more than 2?
> Message-ID:
> <
> cad70eam+hcrddy93c1zoxn6z-ez7+c-dblcwdswps1enk8p...@mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Dear all:
> I would like to query customer from from ooder table and only customer
> order more than twice.
> Which clause or filter should I use to filter those customer order more
> than twice ?
> Please help
> Best regards
> tom
>
>
> ------------------------------
>
> Message: 3
> Date: Sat, 28 Jul 2012 18:50:19 -0700
> From: Peter Aronson <pbaron...@att.net>
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Could anyone recommend books for SQLite
> Message-ID: <501496db.90...@att.net>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> There's a page on the SQLite website about SQLite books at
> http://www.sqlite.org/books.html. I own the first two on the page, and
> like them both. If I was only to get one SQLite book, it'd be the second
> one on the list: Using SQLite by JayKreibich.
>
> Best,
>
> Peter
>
> On 7/28/2012 6:44 PM, ??? wrote:
> > Dear all
> > I am looking for a book ,which include all instructures and
> functions
> > of SQLite. It is like reference guide.
> > Could any help?
> > your sincerely
> > tom
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> ------------------------------
>
> Message: 4
> Date: Sat, 28 Jul 2012 23:46:56 -0400
> From: "Igor Tandetnik" <itandet...@mvps.org>
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] How to query data in table more than 2?
> Message-ID: <jv2bnn$qkb$1...@dough.gmane.org>
> Content-Type: text/plain; charset="utf-8"
>
> ??? <huangchen...@gmail.com> wrote:
> > I would like to query customer from from ooder table and only customer
> > order more than twice.
>
> select CustomerId from Orders group by CustomerId having count(*) > 2;
>
> --
> Igor Tandetnik
>
>
>
> ------------------------------
>
> Message: 5
> Date: Sat, 28 Jul 2012 23:57:20 -0400
> From: C M <cmpyt...@gmail.com>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Subject: Re: [sqlite] MIN() for a timedelta?
> Message-ID:
> <CAAt3jwF=NW68o=
> 4hps7c6ks+pbr1uk4_wewqy28cdgzyfyh...@mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Thanks everyone for the various replies and help. Very useful and I
> will look into the differences and if I have questions about how these
> work will let you know.
>
> Thank you,
> Che
>
>
> ------------------------------
>
> Message: 6
> Date: Sun, 29 Jul 2012 12:38:07 +0530
> From: "Navaneeth.K.N" <navaneet...@gmail.com>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Subject: Re: [sqlite] Handling concurrent read request to SQLite
> Message-ID:
> <CAJSAyaWDsOhHK8Q=
> 14sdg00pgbdwr0vevynogypcqk+7arq...@mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> On Thu, Jul 26, 2012 at 11:37 AM, Simon Slavin <slav...@bigfraud.org>
> wrote:
>
> >
> > Have you set a timeout ? If you haven't the SQLite functions never back
> > off and retry when they find the database locked, they just immediately
> > return an error.
> >
>
> Thanks a lot. I didn't know about this feature. I will give it a try.
>
> --
> -n
>
>
> ------------------------------
>
> Message: 7
> Date: Sun, 29 Jul 2012 12:47:15 +0530
> From: "Navaneeth.K.N" <navaneet...@gmail.com>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Subject: [sqlite] Unknown module FTS4
> Message-ID:
> <
> cajsayaxmnnqqvqkdy_mvmjo+gnr8hsqdnz-2+cqtbktm12w...@mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Hello,
>
> I have a weird problem.
>
> I am working on a shared library, written using C and a GUI application
> written on C++. GUI application uses the shared library. This shared
> library uses SQLite amalgamation and links statically. GUI also uses SQLite
> for some configuration purpose. It is also statically linked. Both of them
> uses latest SQLite version.
>
> My shared library uses FTS4. I have enabled FTS4 by providing the compile
> time options while compiling the shared library. All works well with the
> shared library. All my tests in the shared library codebase is passing.
> Problem happens when I start using this in the GUI program. I am getting
> error like, "Unknown module FTS4". This is weird because I have it linked
> statically in my shared library and all this GUI program does is to
> dynamically link to my library. When I set the FTS compilation options to
> the GUI program, error goes away and all works well.
>
> I am not sure why this is happening. Any help would be great!
>
> --
> -n
>
>
> ------------------------------
>
> Message: 8
> Date: Fri, 27 Jul 2012 22:50:55 +0800
> From: "yanhong.ye" <y...@sohu.com>
> To: sqlite-users@sqlite.org
> Subject: [sqlite] how to process password
> Message-ID: <800249f4-8c76-4fbb-98e5-d3b3a35bd...@sohu.com>
> Content-Type: text/plain; charset=GB2312
>
> I need insert any my bank-card information to sqlite db, so when I insert
> the car number like '3312' and car password like '7711', but I wanna nobody
> can see the password, so I create a function encode('7711','key') and
> decode(select from stable where carnum=3312, 'key') to see the password,
> the key is like 'plkey777' to encode or decode the password , but I don't
> know how to realize that. and I have a function to encode and decode :
> procode(aa,bb,flag);
> char *aa="plkey777";
> char *bb="7711";
> procode(aa,bb,1); //here is to encoding the char ,bb result is bb
>
> insert into stable select "3312",bb;
>
>
> procode(aa,bb,2); //here is to decoding the char ,bb result is bb
> select carbumber,procode(aa,bb,2) from stable
>
> I don't know how to do this. the code upside isPseudo code?
>
> ------------------------------
>
> Message: 9
> Date: Sun, 29 Jul 2012 16:14:49 +0400
> From: Durga D <durga.d...@gmail.com>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Subject: [sqlite] open database on Linux. Already db created on Mac.
> Message-ID:
> <CAANVYQbyDYcrS8VrV8iBzAmPj6+8FKXRLdE6gtOez=
> 4v+tx...@mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi All,
>
> What is the procedure to open the sqlite3 database file in Linux
> Terminal which is already created on Mac.
>
> Thanks in advance.
>
> Regards,
>
>
> ------------------------------
>
> Message: 10
> Date: Sun, 29 Jul 2012 12:21:47 +0000
> From: "Black, Michael (IS)" <michael.bla...@ngc.com>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Subject: Re: [sqlite] EXT : Unknown module FTS4
> Message-ID:
> <ebc3e5c5b813d64186f74954243bb096184a4...@xmbvag73.northgrum.com>
> Content-Type: text/plain; charset="us-ascii"
>
> You probably have another shared library in your path that is getting
> loaded first.
>
> Since you said shared library and not DLL I assume you're using Unix of
> some sort?
>
> Run "ldd" on your GUI app and see what library it says it will use.
>
> Also, you should have either strace or truss which can show you which
> library is getting loaded when it runs.
>
> strace myapp &>myapp.log
>
>
> Michael D. Black
> Senior Scientist
> Advanced Analytics Directorate
> Advanced GEOINT Solutions Operating Unit
> Northrop Grumman Information Systems
>
> ________________________________________
> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org]
> on behalf of Navaneeth.K.N [navaneet...@gmail.com]
> Sent: Sunday, July 29, 2012 2:17 AM
> To: General Discussion of SQLite Database
> Subject: EXT :[sqlite] Unknown module FTS4
>
> Hello,
>
> I have a weird problem.
>
> I am working on a shared library, written using C and a GUI application
> written on C++. GUI application uses the shared library. This shared
> library uses SQLite amalgamation and links statically. GUI also uses SQLite
> for some configuration purpose. It is also statically linked. Both of them
> uses latest SQLite version.
>
> My shared library uses FTS4. I have enabled FTS4 by providing the compile
> time options while compiling the shared library. All works well with the
> shared library. All my tests in the shared library codebase is passing.
> Problem happens when I start using this in the GUI program. I am getting
> error like, "Unknown module FTS4". This is weird because I have it linked
> statically in my shared library and all this GUI program does is to
> dynamically link to my library. When I set the FTS compilation options to
> the GUI program, error goes away and all works well.
>
> I am not sure why this is happening. Any help would be great!
>
> --
> -n
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> ------------------------------
>
> Message: 11
> Date: Sun, 29 Jul 2012 12:23:52 +0000
> From: "Black, Michael (IS)" <michael.bla...@ngc.com>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Subject: Re: [sqlite] EXT : open database on Linux. Already db created
> on Mac.
> Message-ID:
> <ebc3e5c5b813d64186f74954243bb096184a4...@xmbvag73.northgrum.com>
> Content-Type: text/plain; charset="us-ascii"
>
> You familiar with the sqlite3 shell?
> sqlite-shell here:
> http://www.sqlite.org/sqlite-shell-linux-x86-3071300.zip
>
> sqlite3 filename
>
> Michael D. Black
> Senior Scientist
> Advanced Analytics Directorate
> Advanced GEOINT Solutions Operating Unit
> Northrop Grumman Information Systems
>
> ________________________________________
> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org]
> on behalf of Durga D [durga.d...@gmail.com]
> Sent: Sunday, July 29, 2012 7:14 AM
> To: General Discussion of SQLite Database
> Subject: EXT :[sqlite] open database on Linux. Already db created on Mac.
>
> Hi All,
>
> What is the procedure to open the sqlite3 database file in Linux
> Terminal which is already created on Mac.
>
> Thanks in advance.
>
> Regards,
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> ------------------------------
>
> Message: 12
> Date: Sun, 29 Jul 2012 09:43:14 -0500
> From: Robert Myers <rob.my...@ziften.com>
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] how to process password
> Message-ID: <50154c02.9000...@ziften.com>
> Content-Type: text/plain; charset=GB2312
>
> Encryption is very hard to do right, so in general, let someone else do it.
>
> We use SEE (http://www.hwaci.com/sw/sqlite/see.html) with the key
> generated from a password by PBKDF2 and a high number of iterations.
> Previously, columns were encrypted with OS functions that made it
> impossible to move the database from machine to machine, as well as
> really bloating up the data in those columns.
>
> Don't forget to pull the password from secure functions, don't take it
> from the command line or getline.
>
> On 7/27/2012 9:50 AM, yanhong.ye wrote:
> > I need insert any my bank-card information to sqlite db, so when I
> insert the car number like '3312' and car password like '7711', but I wanna
> nobody can see the password, so I create a function encode('7711','key')
> and decode(select from stable where carnum=3312, 'key') to see the
> password, the key is like 'plkey777' to encode or decode the password , but
> I don't know how to realize that. and I have a function to encode and
> decode : procode(aa,bb,flag);
> > char *aa="plkey777";
> > char *bb="7711";
> > procode(aa,bb,1); //here is to encoding the char ,bb result is bb
> >
> > insert into stable select "3312",bb;
> >
> >
> > procode(aa,bb,2); //here is to decoding the char ,bb result is bb
> > select carbumber,procode(aa,bb,2) from stable
> >
> > I don't know how to do this. the code upside isPseudo code?
> > _______________________________________________
> >
>
>
>
> ------------------------------
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> End of sqlite-users Digest, Vol 55, Issue 29
> ********************************************
>
--
黃楨民
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
