Re: [sqlite] Student's t-test table

LUES('80', 1.292, 1.664, 1.99, 2.374, 2.639, 2.887, 3.195, 3.416); INSERT INTO "distribuitions" VALUES('90', 1.291, 1.662, 1.987, 2.369, 2.632, 2.878, 3.183, 3.402); INSERT INTO "distribuitions" VALUES('100', 1.29, 1.66, 1.984, 2.364, 2.626, 2.871, 3.174, 3.391); INSERT INTO &q

Re: [sqlite] Student's t-test table

if it serves to someone I have attached it regards 1966bc On Sun, Nov 16, 2014 at 8:56 AM, Giuseppe Costanzi <giuseppecosta...@gmail.com> wrote: > Thanks Simon, I know how to perform the importation. > However thanks of the idea. > I start looking for it. > > On Sun, No

Re: [sqlite] Student's t-test table

Thanks Simon, I know how to perform the importation. However thanks of the idea. I start looking for it. On Sun, Nov 16, 2014 at 8:46 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 16 Nov 2014, at 7:39am, Giuseppe Costanzi <giuseppecosta...@gmail.com> > wr

[sqlite] Student's t-test table

Hi to everybody, do you know if a database exists in sqlite with the values, degrees of fredom vs probability (alfa) of the t Student? I need it to calculate confidence intervals to compare two means regards bc1966 ___ sqlite-users mailing list

Re: [sqlite] -init file

= LIST separator = "|" main prompt = "sqlite> " continue prompt = " ...> " found on http://www.linuxcommand.org/man_pages/sqlite31.html regards beppe On Sat, Aug 23, 2014 at 6:35 PM, Simon Slavin <slav...@bigfraud.org> wrot

[sqlite] -init file

HI all, I am trying to open an sqlite3 shell session passing a configuration file with the option -init but the console it doesn't shape my file, setconsole headers = ON mode= COLUMN timer = ON pep@hal9000:~/test/server$ sqlite3 -init setconsole test.db SQLite version 3.7.13 Enter

Re: [sqlite] After ANALYZE all has become slow

ore rows are available and accumulates > the retrieved row tuples as a list (all executed in C code, not in python > code, so it should be relatively the same efficiency as the sqlite3 shell > tool is). > > > >>-Original Message- >>From: sqlite-

Re: [sqlite] After ANALYZE all has become slow

)] > [(u'MAX_SCHEMA_RETRY=50',)] > [(u'SOUNDEX',)] > [(u'SYSTEM_MALLOC',)] > [(u'TEMP_STORE=2',)] > [(u'THREADSAFE=1',)] > [(None,)] > [(None,)] > [(None,)] > [(None,)] > [(None,)] >>>> > >>-Original Message- >>From: sqlite-users-boun...

Re: [sqlite] After ANALYZE all has become slow

On Thu, Aug 7, 2014 at 2:50 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 7 Aug 2014, at 10:56am, Giuseppe Costanzi <giuseppecosta...@gmail.com> > wrote: > > > Hi to everybody, > > I have the following problem, on a database, 20M on a se

[sqlite] After ANALYZE all has become slow

Hi to everybody, I have the following problem, on a database, 20M on a server linux, when I make ANALYZE all the interrogations become slow. The database is constituted by 37 tables, 56 views and varied indexes. I use python database API 2.0 to talking with clients. Considering that the data base

Re: [sqlite] Date in gridview visualized in YYYY-MM-DD format:

as others have suggested you strftime('%d-%m-%Y', mytalbe.myfield) regards beppe On Wed, Mar 19, 2014 at 10:39 PM, Stefano Ravagni wrote: > Hello, i'm new in SQLite develop... > > i'n a gridview (.NET) i visualize the data type in -MM-DD format > > Using

[sqlite] explain me EXPLAIN and EXPLAIN QUERY PLAN

hi, where I can find a good documentation, of keywords in object? I would want to learn well meaning and use of opcode, p1, p2, pn ,comment and order,from,detail... I don't succeed in understanding the output of these two keywordses. wishes and good year to everybody. beppe

Re: [sqlite] GROUP BY months and years using integer data

clear how Booleans are used mathematically in high-level > code. Have a great day! > Ryan > > > [1] - http://www.statisticbrain.com/hair-loss-statistics/ > > > > On 2013/12/21 22:24, Giuseppe Costanzi wrote: > >> ...but stats.which_month is not a boolean, it repres

Re: [sqlite] GROUP BY months and years using integer data

...but stats.which_month is not a boolean, it represent a month... On Sat, Dec 21, 2013 at 9:11 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 21 Dec 2013, at 7:45pm, Giuseppe Costanzi <giuseppecosta...@gmail.com> > wrote: > > > I am not sure to have u

Re: [sqlite] GROUP BY months and years using integer data

thanks to all for the solutions. I am not sure to have understood the Igor's solution ...SUM(stats.quantity * (stats.which_month = 1)) AS gen which is the meaning of the operator * in the statement? regards and still thanks beppe On Sat, Dec 21, 2013 at 8:21 PM, James K. Lowden

[sqlite] GROUP BY months and years using integer data

HI all, I've a table such CREATE TABLE 'stats' ( 'stat_id' INTEGER PRIMARY KEY, 'test_id' INTEGER, 'quantity' INTEGER, 'which_month' INTEGER, 'which_year' INTEGER, ) and I need to extract data with somenthing like SELECT stats.which_year AS year, CASE WHEN

Re: [sqlite] GROUP BY

quot;1""12-11-2013" "Siemens" "1" "6""4""2" > > "1""12-11-2013" "Siemens" "1" "2""2""0" > > "2

Re: [sqlite] GROUP BY

On Thu, Nov 14, 2013 at 11:04 AM, Clemens Ladisch <clem...@ladisch.de>wrote: > Giuseppe Costanzi wrote: > > order_idissuedcompany dep_id qty,dispatch surplus > > "1""12-11-2013" "Siemens" "1" &qu

[sqlite] GROUP BY

hi to everybody, you excuse for the preceding mails but I have had problems with this and I have had to change provider. However I propose my question. I have this query, that you also see in attachment file. SELECT orders.order_id AS order_id, strftime('%d-%m-%Y', orders.issued) AS issued,

Re: [sqlite] Syntax control

On Fri, 2012-09-21 at 08:33 +0200, Giuseppe Costanzi wrote: > hi all, > could you check me the syntax of this statment? > > UPDATE batchs > SET > batchs.department_id = (SELECT > products.department_id >

[sqlite] Syntax control

hi all, could you check me the syntax of this statment? UPDATE batchs SET batchs.department_id = (SELECT products.department_id FROM products WHERE products.product_id = batchs.product_id)

Re: [sqlite] Update case in a transaction

On Fri, 2012-03-16 at 12:28 -0400, Igor Tandetnik wrote: > On 3/16/2012 11:59 AM, Giuseppe Costanzi wrote: > > CREATE TRIGGER update_stocks AFTER INSERT ON transactions > > BEGIN > > UPDATE products > > SET > > products.stock =(CASE > >

[sqlite] Update case in a transaction

Hi all, I would create a trigger to update a field in a table when in another table a new record is insert My scenario is products table product_id = INTEGER PK product = TEXT stock = INTEGER transactions table transaction_id = INTEGER PK product_id = INTEGER FK flow = BOOLEAN (0,1) quantitty

[sqlite] Between And statement too much slow

Hi, I'm using this query on my aplication to retrive a recordset that shows transactions between two date. The problem is that it's too much slow. I'm using python and the field TransactionDate is Datetime (e.g. 2008-01-01) and i passed some such parameters ('1', datetime.date(2008, 7, 1),

Re: [sqlite] Extract month and year from a datetime field

Igor Tandetnik wrote: > Giuseppe Costanzi <[EMAIL PROTECTED]> wrote: > >> How extract the month and/or year from a datetime field? >> For example: >> >> SELECT OrderID,OrderDate >> FROM tblOrders >> > > select OrderID, strftime(