Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

In a way it already does… not to the mailing list but to the email address of everyone registered on the forum. The key thing you can’t do is post via email. My personal view is there never be a solution that will please everyone. But it is Richard’s software and Richard’s game, and we have to

Re: [sqlite] No feedback for executing a mathematical expression

Hi, Besides the most excellent explanation given by Keith Medcalf, I want to point out a couple of (hopefully) helpful things – 1. Contrary to your subject line, SQLite actually does give a feedback/returns something. It is just not good enough (for many of us). Consider the following: ``` ○

Re: [sqlite] No feedback for executing a mathematical expression

A very helpful and clear explanation to many of us not familiar with SQLite’s math idiosyncracies, or simply needing a refresher. Many thanks Keith. > On Mar 10, 2020, at 8:57 AM, Keith Medcalf wrote: > > > On Tuesday, 10 March, 2020 01:22, Octopus ZHANG > wrote: > >> I try to run a simple

Re: [sqlite] speeding up an FTS5 search with a JOIN

(deleted=? AND deleted=?) | `--SEARCH TABLE t1 USING COVERING INDEX ix_t1_t1Id (deleted=? AND t1Id=?) |--SCAN SUBQUERY 1 AS a `--LIST SUBQUERY 2 `--SCAN TABLE vt1 VIRTUAL TABLE INDEX 0:m No idea what is going on. > On Mar 9, 2020, at 2:08 PM, P Kishor wrote: > > > >> On

Re: [sqlite] speeding up an FTS5 search with a JOIN

> On Mar 9, 2020, at 1:04 PM, Dan Kennedy wrote: > > > On 9/3/63 01:44, Puneet Kishor wrote: >> Update: so, after much hitting of my head against the wall of sql, I came up >> with the following – as noted above, I really have two distinct set of >> queries I can do separately like so >>

[sqlite] speeding up an FTS5 search with a JOIN

Hi Dan, > On Sat Mar 7 13:32:54 UTC 2020,Dan Kennedy danielk1977 at gmail.com wrote: >> On 7/3/63 14:58, P Kishor wrote: [snipped] >> The actual query, in this case, takes ~47ms. So far so good. But the problem >> occurs when I join the two tables >> >> `

[sqlite] speeding up an FTS5 search with a JOIN

I asked this question on Stackoverflow with not much success, and a suggestion to ask it on the list. So here I am. I have two tables, t1(id, t1Id, … other cols …, fullText) and a FTS5 virtual table vt1(t1Id, fullText) ``` sqlite> EXPLAIN QUERY PLAN ...> SELECT Count(*) as num FROM t1 WHERE

[sqlite] escaping search terms in queries with bind params

Using FTS5 (sqlite3 3.29.x), the following works > SELECT Count(id) AS c FROM t JOIN v ON t.id = v.id WHERE v MATCH 'Trematoda > awaiting allocation’; but the following fails > SELECT Count(id) AS c FROM t JOIN v ON t.id = v.id WHERE v MATCH 'Trematoda > (awaiting allocation)’; Error: fts5:

Re: [sqlite] Feature request: extend the IN operator

On Mon, Aug 8, 2011 at 2:19 AM, Igor Tandetnik wrote: > Alexey Pechnikov wrote: >> 2011/8/7 Simon Slavin : >>> You don't need to. The SQLite expressions I listed tell you how to achieve >>> the result without doing that. >> >>

Re: [sqlite] Question about SQLite features.

On Thu, Nov 11, 2010 at 5:36 PM, Petite Abeille wrote: > > On Nov 12, 2010, at 12:31 AM, Jay A. Kreibich wrote: > >>  There have been many proposals to do just this, and in specific, >>  with Lua.  Outside of some moderate technical issues, the >>  big problem is the

Re: [sqlite] Full text search FTS3 of files

On Sun, Oct 17, 2010 at 2:54 PM, pipilu wrote: > Hi: > I am trying to build a sqlite3 database to index files. What I want to do is > to keep the files in the file system on the disk (not in the database) and > index the files with keywords such that when a search is performed,

Re: [sqlite] Multiple prepared statements

On Fri, Oct 15, 2010 at 8:43 AM, Andrew Davison wrote: > In my database I do lots of inserts, of exactly the same nature so I use > a prepared statement, which I cache, always reseting after use. Works fine. > > Now I decide that I want a second type of insert, so I try

Re: [sqlite] Nth row of on sqlite DB

On Thu, Oct 14, 2010 at 11:15 AM, Kavita Raghunathan <kavita.raghunat...@skyfiber.com> wrote: > Please see comment > > > On 10/14/10 11:02 AM, "P Kishor" <punk.k...@gmail.com> wrote: > > >>> Hello, >>> I¹ve been adding and deleting ro

Re: [sqlite] Nth row of on sqlite DB

On Thu, Oct 14, 2010 at 10:54 AM, Kavita Raghunathan wrote: > 3. How can I make my primary ID remain sequential even after a delete of row. > Can sqlite somehow realign the indices after a row in the middle is deleted ? > If you can change the "primary ID"

Re: [sqlite] Adding a string in front of what is already in a field

José, Please note Igor's very important cautionary note below -- On Mon, Oct 11, 2010 at 7:05 AM, Igor Tandetnik <itandet...@mvps.org> wrote: > P Kishor <punk.k...@gmail.com> wrote: >> UPDATE OpenJobs >> SET notes = 'string to add in front\r\n' || notes >> WHER

Re: [sqlite] Adding a string in front of what is already in a field

On Sun, Oct 10, 2010 at 11:05 PM, jose isaias cabrera wrote: > > Greetings. > > I would like some help with this scenario... DB name OpenJobs. > > id,pid,spid,notes > 100, 24,32,'this is a test' > 101, 24,32,'a different note' > 102, 24,32,'yet, another different note' >

Re: [sqlite] ADD UNIQUE CONSTRAINT

add a column. You can always update the new constraint-full column with the value from the old constraint-less column. Or, recreate the table and copy data from the old table. > > On Sun, Oct 10, 2010 at 10:54 AM, P Kishor <punk.k...@gmail.com> wrote: > >> On Sun, Oct 10,

Re: [sqlite] ADD UNIQUE CONSTRAINT

On Sun, Oct 10, 2010 at 2:45 AM, Fadhel Al-Hashim wrote: > Good day, > > is it possible to Alter a table and add a unique constraint on one or more > columns? > See http://www.sqlite.org/lang_altertable.html In particular -- "The ADD COLUMN syntax is used to add a new column

Re: [sqlite] using SQLite with mod_perl

On Sat, Oct 9, 2010 at 6:24 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 9 Oct 2010, at 7:49am, P Kishor wrote: > >> > > My answers to these things are a little weird and I'm not sure I understand > at all what you're doing.  But it's a weekend so I'l

[sqlite] using SQLite with mod_perl

This is a perl question really, so apologies to the SQLite community. However, I am stuck, and I am flailing on various forums (perlmonks/stackoverflow), hoping to strike lucky. My problem is that I am running into the "database locked" error under mod_perl with Apache2. I thought I had surmounted

Re: [sqlite] Involving in sqlite development

why don't you start with... On Fri, Oct 8, 2010 at 8:28 AM, sjtirtha wrote: > Hi, > > Here is what I want to do: > 1. I want to learn more about SQL Database implementation the above. You will be quite busy doing the above. When you are good at the above, you can definitely

Re: [sqlite] Involving in sqlite development

On Thu, Oct 7, 2010 at 4:26 PM, sjtirtha wrote: > Hi, > > I'm interested involving in sqlite development. > How can I start it? You really need to explain further and more clearly what you want to do before anyone will be able to guide you. > > Regards > Steve >

Re: [sqlite] Speed up DELETE of a lot of records

On Thu, Oct 7, 2010 at 11:05 AM, Michele Pradella wrote: >  Hi all, I have a question about how to speed up a DELETE statement. > I have a DB of about 3GB: the DB has about 23 millions of records. > The DB is indexed by a DateTime column (is a 64 bit integer), and >

Re: [sqlite] Vertical -> Horizontal transformation

On Wed, Sep 29, 2010 at 11:34 AM, Andy Chambers wrote: > Hi, > > I've got a nice normalized table and need to produce a de-normalized > view of this table (i.e. convert it > from tall skinny, into wide short table).  In order to do this, I was > planning on just joining

Re: [sqlite] Length=10

On Wed, Aug 25, 2010 at 10:05 AM, Ted Rolle Jr. wrote: > I have a table of UPCs with lengths varying from 6 to 12.  I'd like to > print those with length=10 to a file for printing. > SELECT * >  FROM UPCs >  WHERE LENGTH(UPC)=10; > works just fine.  But when I export the table

Re: [sqlite] how to get the number of rows in a a table?

On Tue, Jul 20, 2010 at 11:41 AM, dmsmsm wrote: > > how to get the number of rows in a a table? what is the function to get that? > Please add a sample code to achive that. SELECT Count(*) FROM table; ___ sqlite-users mailing

Re: [sqlite] ON conditions vs. WHERE conditions

On Tue, Jul 20, 2010 at 9:43 AM, Jean-Christophe Deschamps wrote: > What is the rationale about placing complex conditions in the ON part > of an inner join rather than in an WHERE clause? My sense is that it is not so much about "complexity" but more about the logic of the

Re: [sqlite] How to concat column

On Fri, Jul 9, 2010 at 2:35 PM, Peng Yu <pengyu...@gmail.com> wrote: > On Sun, Jul 4, 2010 at 7:15 PM, P Kishor <punk.k...@gmail.com> wrote: >> On Sun, Jul 4, 2010 at 6:15 PM, Peng Yu <pengyu...@gmail.com> wrote: >>> Hi, >>> >>>

Re: [sqlite] Numbers as CHARs.

On Tue, Jul 6, 2010 at 8:45 PM, Pavel Ivanov wrote: >>> The receiving field is defined as CHAR; [snip] >> SQLite has no such type.  Define the fields as TEXT instead: > > Simon, please don't confuse poor users. SQLite will work perfectly and > indistinguishably well with both

Re: [sqlite] Numbers as CHARs.

On Tue, Jul 6, 2010 at 5:10 PM, Ted Rolle, Jr. wrote: > I, (or more to the point, SQLite) can't seem to retain leading zeros > on numbers. > > The receiving field is defined as CHAR; > I'm using the SQLite Manager in Firefox. > I've also tried sqlite3 from the command line. >

Re: [sqlite] "use database" in sqlite3?

On Tue, Jul 6, 2010 at 11:00 AM, Peng Yu wrote: > Hi, > > I can attach a database to the current session. But I have to > explicitly specify the table name to refer to any tables in it (such > 'create_index' in 'create_index.sqlite_master'). Is there a command > similar to

Re: [sqlite] How to concat column

On Sun, Jul 4, 2010 at 6:15 PM, Peng Yu wrote: > Hi, > > I only find row-wise concatenation by not column-wise. > > For example, I have table > > x1 y1 > x1 y2 > x2 y3 > x4 y4 > > I want to have the second column concatenated based on the value in > the first column to get

Re: [sqlite] How to supply no values when inserting a record?

On Fri, Jul 2, 2010 at 9:28 PM, Peng Yu <pengyu...@gmail.com> wrote: > On Fri, Jul 2, 2010 at 8:58 PM, P Kishor <punk.k...@gmail.com> wrote: >> On Fri, Jul 2, 2010 at 8:52 PM, Pavel Ivanov <paiva...@gmail.com> wrote: >>>> I tried the following two command

Re: [sqlite] How to supply no values when inserting a record?

On Fri, Jul 2, 2010 at 8:52 PM, Pavel Ivanov wrote: >> I tried the following two commands. Neither of them work. Would >> you please let me know what is the command to insert a record with the >> default value? > > Try this: > insert into test default values; > > Peng, Now

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=ntimes and only show n times if it appears more than n times?

On Fri, Jul 2, 2010 at 12:06 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > P Kishor <punk.k...@gmail.com> wrote: >> I think what Peng wants is that given table of type_id >> >> 5 >> 5 >> 5 >> 5 >> 5 >> 4 >> 4 >> 4 >

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=n times and only show n times if it appears more than n times?

pears <=n times > and only show n times if it appears more than n times? > > > > On Fri, Jul 2, 2010 at 11:19 AM, P Kishor <punk.k...@gmail.com> wrote: >> On Fri, Jul 2, 2010 at 11:19 AM, P Kishor <punk.k...@gmail.com> wrote: >>> On Fri, Jul 2, 2010 at 1

Re: [sqlite] How to select an entry that appears <=n times and only show n times if it appears more than n times?

On Fri, Jul 2, 2010 at 11:19 AM, P Kishor <punk.k...@gmail.com> wrote: > On Fri, Jul 2, 2010 at 11:15 AM, Peng Yu <pengyu...@gmail.com> wrote: >> Hi, >> >> SELECT DISTINCT type_id FROM foods; >> >> If I use 'distinct', any entry that shows up greater

Re: [sqlite] How to select an entry that appears <=n times and only show n times if it appears more than n times?

On Fri, Jul 2, 2010 at 11:15 AM, Peng Yu wrote: > Hi, > > SELECT DISTINCT type_id FROM foods; > > If I use 'distinct', any entry that shows up greater or equal to one > time will only appear once. But I want to select an entry that appears > <=n times and only show n times if

Re: [sqlite] create table {table-name} as select.... table definition is imperfectly cloned

> I saw this on 60 minutes or 20/20 or some show like that  -- I didn't write > that program or install the compatible terminal. But since then, whenever I > see the opportunity for things going FUBAR, I will say something. > > Regards > Tim Romano > Swarthmore PA > > > > >

Re: [sqlite] create table {table-name} as select.... table definition is imperfectly cloned

On Tue, Jun 29, 2010 at 9:58 AM, Tim Romano wrote: > But there may be an argument for making the cloning more precise. The issue is that CREATE TABLE t AS SELECT... is not meant to clone a table. Not too long ago I encountered the same issue (search the mail archives).

Re: [sqlite] Column names in SQL

b] -- 3 sqlite> You are doing something else. You are not describing the entire problem. How are you accessing your database? > On Mon, Jun 28, 2010 at 6:01 PM, P Kishor <punk.k...@gmail.com> wrote: > >> On Mon, Jun 28, 2010 at 9:58 AM, Serdar Genc <serdar.g...@gmail.

Re: [sqlite] Column names in SQL

On Mon, Jun 28, 2010 at 9:58 AM, Serdar Genc wrote: > Hi everyone, > > I have a problem related to column names . I have a column name as a[b] in > my table but > this creates a problem when using SELECT statement as > SELECT a[b] from Table. I know [] is a special

Re: [sqlite] composite PK vs. single PK

Thanks Cory. On Fri, Jun 25, 2010 at 9:07 AM, Cory Nelson <phro...@gmail.com> wrote: > On Fri, Jun 25, 2010 at 6:49 AM, P Kishor <punk.k...@gmail.com> wrote: >> Is there any gotcha, any disadvantage (query complexity, db size, >> query speed) to using a composite PK

[sqlite] composite PK vs. single PK

Is there any gotcha, any disadvantage (query complexity, db size, query speed) to using a composite PK (two columns) vs. a single AUTOINCREMENT INT? Background: I happen to have the two columns in question in my table anyway. Adding an INTEGER PRIMARY KEY would use up space I don't want to use.

Re: [sqlite] understanding the logic of licensing various parts of the sqlite family

On Thu, Jun 24, 2010 at 3:19 PM, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Jun 24, 2010 at 4:15 PM, P Kishor <punk.k...@gmail.com> wrote: > >> >> Right then. That explains #3 above. Are you saying that #5 is >> available for a fee? And, is there a descript

Re: [sqlite] understanding the logic of licensing various parts of the sqlite family

On Thu, Jun 24, 2010 at 3:04 PM, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Jun 24, 2010 at 3:58 PM, P Kishor <punk.k...@gmail.com> wrote: > >> I am simply curious, and want to expand my knowledge of this -- >> >> 1. sqlite3 code is in public domain. &g

[sqlite] understanding the logic of licensing various parts of the sqlite family

I am simply curious, and want to expand my knowledge of this -- 1. sqlite3 code is in public domain. 2. sqlite mark is trademarked. 3. sqlite3 encryption extension is licensed and for a fee, and comes with a contract to not distribute it further. 4. sqlite code tests are available as long as they

Re: [sqlite] how often to open the db

On Mon, Jun 21, 2010 at 10:44 PM, Sam Carleton wrote: > I have asked this Q a number of times over the last year and NEVER gotten > ANYONE to even comment on it.  I am wondering why: > > Am I opening the DB too much? what is too much? I mean, the computer is not going

Re: [sqlite] optimizing use of extension function

On Sun, Jun 20, 2010 at 9:21 PM, Sam Carleton wrote: > SELECT FolderId, ImageId, instertedon FROM V_FAVORITES_SELECTED >  WHERE case when instertedon > julianday(@time) >   then findLargeImage(@path, FolderId, ImageId) >   else 0 end; I think Igor wants you to add the

Re: [sqlite] optimizing use of extension function

ed, the result set is already out of the bag, it has already been calculated. In any case, I don't have a definitive citation for my belief, so I am happy to be corrected. > > > Pavel > > On Sun, Jun 20, 2010 at 8:56 PM, P Kishor <punk.k...@gmail.com> wrote: >> On Sun

Re: [sqlite] optimizing use of extension function

On Sun, Jun 20, 2010 at 7:53 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 21 Jun 2010, at 12:41am, P Kishor wrote: > >> iirc, LIMIT 1 is applied *after* the WHERE clause is satisfied. In >> other words, the entire result set is returned, and then it is &

Re: [sqlite] Question About SQLITE and AIR efficiency

On Sun, Jun 20, 2010 at 5:18 PM, Simon Slavin wrote: > > On 20 Jun 2010, at 11:11pm, Felipe Aramburu wrote: > >> I have a query that I can execute in about 150ms in a sqlite tool like >> sqlite expert professional that takes 1200ms when I execute the query from >> AIR > >

Re: [sqlite] optimizing use of extension function

On Sun, Jun 20, 2010 at 5:16 PM, Simon Slavin wrote: > > On 20 Jun 2010, at 11:08pm, Sam Carleton wrote: > >> Simon, >> >> this is a direct CUT and PASTE from my code: >> >> #define SQL_GET_NEXT_SLIDE_SHOW_IMAGE \ >>       "SELECT FolderId, ImageId, instertedon " \ >>      

Re: [sqlite] optimizing use of extension function

WHERE <> Go back to what Igor showed you -- SELECT folderid, imageid, insertedon FROM v_favorites_selected WHERE CASE WHEN instertedon > julianday(@time) THEN findImage(@rootPath, FolderId, ImageId) ELSE 0 END; On Sun, Jun 20, 2010 at 3:52 PM, P Kishor

Re: [sqlite] optimizing use of extension function

On Sun, Jun 20, 2010 at 3:47 PM, Sam Carleton wrote: > Erin and Igor, > > I simply cannot wrap my head around the correct syntax.  BAsed on the > documentation, I believe I should be looking to make it fit this > pattern: > > CASE WHEN x=w1 THEN r1 WHEN x=w2 THEN r2

Re: [sqlite] BLOB Support

y good. Also something to > consider if you will store large files. > > /Andreas > > On Wed, Jun 16, 2010 at 1:31 PM, P Kishor <punk.k...@gmail.com> wrote: > >> for some reason, I remember you asking the same question not too long >> ago, and getting a bunch

Re: [sqlite] BLOB Support

for some reason, I remember you asking the same question not too long ago, and getting a bunch of answers. I recall chipping in with an answer myself. DIdn't any of those answers help? On Wed, Jun 16, 2010 at 1:58 AM, Navaneeth Sen B wrote: > Hi All, > I would like to

Re: [sqlite] no such table error.

On Mon, Jun 14, 2010 at 5:53 PM, Tom Lynn wrote: > I'm fairly new to sqlite and generally use databases with single tables for > use with my PERL scripts.  I've encountered a problem where I've tried to > insert data into a table named trunks and get the error "No such table: >

Re: [sqlite] Mail loop?

Funny that... I got the "mail loop error" reply to my email below > This is the mail system at host sqlite.org. > > I'm sorry to have to inform you that your message could not > be delivered to one or more recipients. It's attached below. > > For further assistance, please send mail to

Re: [sqlite] Mail loop?

On Mon, Jun 14, 2010 at 8:09 AM, Black, Michael (IS) wrote: > The problem is that somebody has a .forward or such which loops back to the > list.  It's probably in the alias expansion of sqlite-users which expands to > a listfor which a member then expands back to

Re: [sqlite] Storing AVCHD files

On Wed, Jun 9, 2010 at 8:49 AM, Jean-Denis Muys wrote: > > On 6/9/10 14:37 , "Simon Slavin" wrote: > >> >> On 9 Jun 2010, at 12:18pm, Navaneeth Sen B wrote: >> >>> I would like to know how i can store an AVCHD file(It has a folder >>> structure) having

Re: [sqlite] returning a larger snippet in FTS3 match

On Tue, Jun 8, 2010 at 9:14 AM, Jay A. Kreibich <j...@kreibi.ch> wrote: > On Tue, Jun 08, 2010 at 08:49:22AM -0500, P Kishor scratched on the wall: >> On Tue, Jun 8, 2010 at 8:29 AM, Jay A. Kreibich <j...@kreibi.ch> wrote: >> > On Tue, Jun 08, 2010 at 06:56:

Re: [sqlite] returning a larger snippet in FTS3 match

On Tue, Jun 8, 2010 at 8:29 AM, Jay A. Kreibich <j...@kreibi.ch> wrote: > On Tue, Jun 08, 2010 at 06:56:33AM -0500, P Kishor scratched on the wall: >> Hi all, re-asking this in case it missed some of the keener eyes -- I >> am using the Snippet() function to return a sn

Re: [sqlite] returning a larger snippet in FTS3 match

Hi all, re-asking this in case it missed some of the keener eyes -- I am using the Snippet() function to return a snippet of text from my FTS3 table showing the MATCH context. I would like to make the returned snippet longer. Is that possible? On Sun, Jun 6, 2010 at 10:36 AM, P Kishor <pun

[sqlite] returning a larger snippet in FTS3 match

I would like to return a much larger snippet in the MATCH results than what comes back as default. Is it possible to specify a snippet length? -- Puneet Kishor ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] FTS1 or FTS2

On Wed, May 26, 2010 at 9:22 PM, Sam Carleton wrote: > Roger, > > I did this search: > > http://www.google.com/search?q=sqlite+text+search > > The top link points here: > > http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex > > Thus I learned of FTS1 and FTS2, maybe

Re: [sqlite] Novice SQLite user

On Wed, May 26, 2010 at 8:15 PM, jdee5 wrote: > > > > Thanks for your reply.  I have read through the link you suggested, very > helpful...if I may ask another question concerning this.  Say on my > application I have 2 users reading some of the database contents at the same

Re: [sqlite] FTS1 or FTS2

On Wed, May 26, 2010 at 1:47 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 05/26/2010 10:24 AM, Sam Carleton wrote: >> If I do opt to use FTS, which one should I be using, FTS1 or FTS2? >> According to the web site, it should be FTS1,

Re: [sqlite] OperationalError: no such function: group_concat

On Tue, May 18, 2010 at 12:00 AM, zeal wrote: > my sqlite3 version is 2.3.2 > is it out of date? yes. > which version should i install? > the latest. .. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] prevent sqlite from interpreting string as numbers?

On Mon, May 17, 2010 at 1:59 PM, peter360 wrote: > > Ah... that is what I missed. Thanks! > > On the other hand, why doesn't sqlite give me an error or warning when I > used "string", if it has no meaning? > Because sqlite doesn't care. You could call it "peter360string"

Re: [sqlite] data type from join multiple tables

On Fri, May 14, 2010 at 11:38 AM, Fabio Spadaro <fabiolinos...@gmail.com> wrote: > Hi, > > 2010/5/14 P Kishor <punk.k...@gmail.com> > >> On Fri, May 14, 2010 at 10:11 AM, Fabio Spadaro <fabiolinos...@gmail.com> >> wrote: >> > Hi, >> > >

Re: [sqlite] data type from join multiple tables

On Fri, May 14, 2010 at 10:11 AM, Fabio Spadaro <fabiolinos...@gmail.com> wrote: > Hi, > > 2010/5/14 P Kishor <punk.k...@gmail.com> > >> On Fri, May 14, 2010 at 9:49 AM, Fabio Spadaro <fabiolinos...@gmail.com> >> wrote: >> > hi, >> > >

Re: [sqlite] data type from join multiple tables

On Fri, May 14, 2010 at 9:49 AM, Fabio Spadaro <fabiolinos...@gmail.com> wrote: > hi, > > 2010/5/14 P Kishor <punk.k...@gmail.com> > >> On Fri, May 14, 2010 at 9:01 AM, Fabio Spadaro <fabiolinos...@gmail.com> >> wrote: >> > I need to identify dat

Re: [sqlite] data type from join multiple tables

On Fri, May 14, 2010 at 9:01 AM, Fabio Spadaro wrote: > I need to identify data types extracted from a > join between multiple tables without using cross-checking table_info more > pragmatic. > Could you clarify what you really want to do? Your question is not clear at

Re: [sqlite] create virtual table if not exists table_id???

On Tue, May 11, 2010 at 1:50 PM, Matt Young wrote: > sqlite> create virtual table if not exists words using fts3  (f1 ); > Error: near "not": syntax error > sqlite> create  table if not exists U (w1 ); > sqlite> > > Different syntax? Yes. > virtual tables don't persist?

Re: [sqlite] sqlite connection?

On Tue, May 11, 2010 at 12:45 PM, john cummings wrote: > hi all, > > i'm new to this forum and sqlite. > > is it possible to have an executable (i.e. .exe) with connections to 2 > sqlite databases? I've never made an executable, but given that I can do so with Perl, I

Re: [sqlite] Insert large data question ??

On Tue, May 11, 2010 at 12:47 AM, 風箏 wrote: > Dear > > I have about 9 million data insert string need to insert into an table ,each > row data is unique > > this is a sample: > insert into mydata > VALUES(38824801,56888,'AABBCC',4.999,157,'2009/9/10 >

Re: [sqlite] Documentation typo

2010/5/10 "Carlos Andrés Ramírez C." : > > Hello guys, > I was breaking my head trying to figure out how to obtain the last > inserted row's ID --- using SQLite from Ruby. > > I found 'last_insert_rowid()' in your documentation at > http://www.sqlite.org/lang_corefunc.html  

Re: [sqlite] Encryption of sqlite DB

On Tue, May 4, 2010 at 11:19 AM, Kavita Raghunathan wrote: > Hi, > What’s the simplest way to encrypt only certain rows in an sqlite DB? If > there is no way to do this (for storing passwords etc), You certainly mean some or all columns in all the rows, don't

Re: [sqlite] SQLite datatypes

On Mon, May 3, 2010 at 2:17 PM, Alan Harris-Reid wrote: > Hi there, > > When creating a table in SQLite, I often get confused when confronted > with all the possible datatypes which imply similar contents, so could > anyone tell me the difference between the following

Re: [sqlite] is it possible to return primary key column from given table ?

On Mon, May 3, 2010 at 2:14 AM, yogibabu wrote: > > like this: SELECT --idcolumn-- FROM `table` what is the name of the column? Is it '--idcolumn--'? Are the leading and trailing '--' part of the name? Remember that leading '--' is used as SQL comments. If that is indeed

Re: [sqlite] scripting language interpreter

On Sat, May 1, 2010 at 9:53 AM, Tim Romano wrote: > Simon, > > It's not clear to me how this is a result of scripting language support: > > "Another problem with it is that sooner or later you need your inner > language (your SQL engine) to have access to your outer

Re: [sqlite] select %column% from table

ould insert. >> >> The fields will be many and include >> >> P$nR >> P$nS >> P$nB >> >> etc. >> >> thats why I wanted a quick way to access "select P%R from TABLE"; >> >> >> thanks again >> >> >> >>

Re: [sqlite] select %column% from table

rialize that hash and store it in the table. > thats why I wanted a quick way to access "select P%R from TABLE"; > > > thanks again > > > > > > > > > > > > > > - Original Message > From: P Kishor <punk.k...@gmail.com>

Re: [sqlite] select %column% from table

crap! I completely misunderstood your question... be confused, and then ignore my reply. On Fri, Apr 30, 2010 at 9:43 AM, P Kishor <punk.k...@gmail.com> wrote: > On Fri, Apr 30, 2010 at 9:28 AM, David Lyon <david_ly...@yahoo.com> wrote: >> If I had a table called TABLE with

Re: [sqlite] select %column% from table

On Fri, Apr 30, 2010 at 9:28 AM, David Lyon wrote: > If I had a table called TABLE with fields P1N..P50N is there a way to > select something like: > > "select P%N from TABLE" > >  to return all the results from columns P1N..P50N or do I have to do it > manually:

Re: [sqlite] 1000 insert statements into empty table taking 20 seconds... very odd!

On Wed, Apr 28, 2010 at 4:08 PM, Ian Hardingham wrote: > Hey guys - this is my first post here, apologies if I violate any etiquette. > > I have a table I create with: > > CREATE TABLE IF NOT EXISTS globalRankingTable (id INTEGER PRIMARY KEY > AUTOINCREMENT, name TEXT NOT NULL

Re: [sqlite] column output truncating

On Fri, Apr 23, 2010 at 10:42 AM, Derek Martin wrote: > On Fri, Apr 23, 2010 at 08:52:37AM -0500, Jay A. Kreibich wrote: >> On Thu, Apr 22, 2010 at 06:31:07PM -0400, Derek Martin scratched on the wall: >> > Hi, >> > >> > I have a query that produces about 10 columns, some of

Re: [sqlite] column output truncating

On Fri, Apr 23, 2010 at 8:39 AM, Adam DeVita wrote: > Could you include a bit more information about your post? (Version number, > operating system etc.) > > I'm unsure if you have compiled something or are using the command line > tool. > >  There are lots of very

Re: [sqlite] Date Dimension

1990 through 2030, and  fill in the month > name, year, quarter in nice user friendly strings.*/ > > Is this approach better than generating a list of date strings for all > possible dates, throwing away the Feb 29s from non leap years, and then > parsing the string to get ye year, month, da

Re: [sqlite] Date Dimension

mail.com> wrote: > >> > What is a "Date Dimension"? >> >> Probably OP meant this: >> http://en.wikipedia.org/wiki/Dimension_(data_warehouse)<http://en.wikipedia.org/wiki/Dimension_%28data_warehouse%29> >> . >> But I don't have any answer to the quest

Re: [sqlite] Direct access of table data

On Wed, Apr 21, 2010 at 1:19 PM, Nathan Biggs wrote: > Is there a way to read the values of a table directly without building > and executing a query.  I have a function that has predefined memory > (counters) and increments them if the data in the record matches a hard > coded

Re: [sqlite] Date Dimension

On Wed, Apr 21, 2010 at 1:50 PM, Adam DeVita wrote: > Good day, > > Given the context I'm in, sqlite is going to be used for our data > warehousing.  (We generate about 2MB of raw data in a month, so we don't > think we need a heavy DB engine.) > > Since most warehouses have

Re: [sqlite] Inserting from other table

col and the blob col, and have a one-to-one relationship between your master table and the blob table. I must also note, as a perl enthusiast, laziness *is* a virtue, but practice safe laziness. > Pavel > > On Mon, Apr 19, 2010 at 1:56 PM, P Kishor <punk.k...@gmail.com> wrote:

Re: [sqlite] Inserting from other table

On Mon, Apr 19, 2010 at 12:47 PM, sabapathy wrote: > > The DB had some 15 columns before. > And there are lot of records saved using the s/w tool. > But in the latest version of tool there are some columns added in DB > inbetween of existing columns. > So to use the

Re: [sqlite] How to fix Syntax - Check exists

On Sat, Apr 17, 2010 at 12:10 AM, gretty wrote: > > Hello > > I am a programmer using SQLite3 to create a database for an application. I > have been running into some problems with my SQL queries which I dont think > are correct. Can you check them & correct them where

Re: [sqlite] Bug

On Thu, Apr 15, 2010 at 3:36 AM, Wiktor Adamski wrote: > SQLite version 3.6.23.1 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> create table t(a); > sqlite> insert into t values(1); > sqlite> insert into t values(2); > sqlite>

Re: [sqlite] copy one row to another

On Wed, Apr 7, 2010 at 6:57 PM, Nicolas Williams wrote: > sqlite> CREATE TABLE foo(id INTEGER PRIMARY KEY, a, b, c); > sqlite> insert into foo values(1, 'a', 'b', 'c'); > sqlite> select * from foo; > 1|a|b|c > sqlite> CREATE TEMP TABLE tempfoo AS SELECT * FROM foo WHERE

Re: [sqlite] copy one row to another

t;>> >>> REPLACE INTO t (id, foo, bar, ...) >>> SELECT 649, foo, bar, ... >>> WHERE id = 651 >>> >> >> I get a "Error: constraint failed". I have no constraint other than >> INTEGER PRIMARY KEY on id. >> >>> >>> P

Re: [sqlite] copy one row to another

On Wed, Apr 7, 2010 at 4:20 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 7 Apr 2010, at 10:06pm, P Kishor wrote: > >> On Wed, Apr 7, 2010 at 3:46 PM, Pavel Ivanov <paiva...@gmail.com> wrote: >>> Probably the only way to do that is >>> >>

  1   2   3   4   5   6   7   8   9   10   >