Re: [sqlite] TRUNCATE TABLE alias for DELETE FROM

Thanks. Good to know. From: Clemens Ladisch <clem...@ladisch.de> To: sqlite-users@sqlite.org Sent: Monday, October 22, 2012 1:02 PM Subject: Re: [sqlite] TRUNCATE TABLE alias for DELETE FROM giris wrote: > Rather, the implementation/internals of SQ

Re: [sqlite] TRUNCATE TABLE alias for DELETE FROM

Hi: Mapping TRUNCATE table to DELETE * is not going to help and seems like a bad idea. TRUNCATE table is an artifact implemented in many SQL implementations, and can make a world of difference in performance when deleting all rows  in a table. It avoids all the overhead of transaction logging,

Re: [sqlite] insert two select count(*) problem

80 ,select count(*) from db2 where db2.sco2>90; Try parenthesizing each (sub)query insert into mydb (co1,co2) (...),(...); Could you clarify your use case for this query? Thanks HTH. From: YAN HONG YE To: "sqlite-users@sqlite.org"

Re: [sqlite] DELETE only deletes some records, not others

As you might know, a float is only approximate, and trying to cast to REAL or another floating point type will not be an exact match, causing the where clause to evaluate false for the row. Fuerger, ensure no NULLs are being inserted in the price field for the same reason above. What are you

Re: [sqlite] select ... where count(*)

To: General Discussion of SQLite Database Sent: Saturday, June 23, 2012 1:21 PM Subject: Re: [sqlite] select ... where count(*) On Jun 23, 2012, at 7:19 PM, Patrik Nilsson wrote: > Great! This works better than mine suggestion. By the way… you might find the fine

Re: [sqlite] select count

Hi: Assuming that the column in A is (for example) named x, the query will be select count(*), x from A group by x q.v "GROUP BY" HTH. Thanks From: Patrik Nilsson To: General Discussion of SQLite Database