Re: [sqlite] autonum primary key
http://www.sqlite.org/faq.html. No. 1. |-+> | | "[EMAIL PROTECTED]| | | " >--| | | | To: sqlite-users@sqlite.org | | cc: | | Subject: [sqlite] autonum primary key | >--| Hi, I need help in generating a unique integer for the table's primary key. I am more familiar with MS Access that has a data type called "Autonum" that generates the integer. Do I need to find the last record to know what the next number should be? Thanks in advance, Bill ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] where I can download sqlite 3.2.8
All the filenames you need to modify are on the download page. Regards. rayB ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] where I can download sqlite 3.2.8
Using the filenames on the downloads page (http://www.sqlite.org/download.html) as skeletons, substitute the file version number you require, i.e. - the current Windows command line program is http://www.sqlite.org/sqlite-3_3_5.zip. This becomes http://www.sqlite.org/sqlite-3_2_8.zip to download the 3.2.8 version. Regards. rayB |-+> | | "yuyen" | | | <[EMAIL PROTECTED]| | | >| | || | | 29/05/2006 14:46 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: | | cc: | | Subject: [sqlite] where I can download sqlite 3.2.8 | >--| Hi, all I need sqlite3.exe and sqlite3.dll of version 3.2.8. Just can't find any previous version on sqlite dfficial site. Please advise how to get the previous verson of sqlite3 binary files or sources files. Jack ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
[sqlite] Re: - [sqlite] NOT NULL in create table command not work
Are you confusing a NULL with an empty (zero length) string? They are not the same. Regards. rayB |-+> | | "Nguyen Dang | | | Quang" | | | <[EMAIL PROTECTED]| | | m> | | || | | 24/05/2006 16:08 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: | | cc: | | Subject: - [sqlite] NOT NULL in create table command not work | >--| Hi guys, I used the following command to create table: create table ne(ne_id integer primary key autoincrement, name varchar(50) not null, directory varchar(256) not null, adaptor_name varchar(50) not null, note varchar(500), filter_rule varchar(50), unique(name), unique(directory)) But my application still insert emty string into DIRECTORY field Why? It's a bug? How can I solve this problems? Thanks ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
[sqlite] Re: - Re: [sqlite] How can I get the type of a column?
Perhaps the analogy is better the other way around - try driving a stick shift after driving an automatic. Takes a gear change or two for you to realise what the other pedal is for. As you mention, this is a constant point of discussion on this board. Perhaps 'Version 3 Data Types' should be given more prominence under 'Documentation'. Alternatively, perhaps the subject should be touched upon briefly in 'SQLite in 5 Minutes Or Less'. Regards. rayB |-+> | | [EMAIL PROTECTED]| | || | | 11/05/2006 10:23 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: sqlite-users@sqlite.org | | cc: | | Subject: - Re: [sqlite] How can I get the type of a column? | >--| sqlite <[EMAIL PROTECTED]> wrote: > Eric Scouten wrote: > > SQLite derives that by parsing the string that you've already found. > > I found the method in section 2.1 of this page: > http://www.sqlite.org/datatype3.html > > > > I think it does store that in some internal fashion, so > > it's not *re-parsing* it constantly, but that is not > > available through the API. > > > > Pity. I guess I'll have to parse it myself... > I continue to be bewildered by programmers' fixation on datatypes. This has been a constant theme for 6 years now. And in all that time, I have never been able to figure out why so many people think they need to know the "type" of a "column". The best theory I have is that people who have always driven a stick shift must have difficulty driving a car with an automatic transmission. -- D. Richard Hipp <[EMAIL PROTECTED]> ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
[sqlite] Re: - [sqlite] Incrementing the value of a column
Try: UPDATE table SET aColumn = someNewValue, numTouched = numTouched + 1 WHERE ; Regards. rayB |-+> | | Tito Ciuro | | | <[EMAIL PROTECTED]> | | || | | 22/03/2006 11:54 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: Forum SQLite | | cc: | | Subject: - [sqlite] Incrementing the value of a column | >--| Hello, This is the schema: ROWID INTEGER, myText TEXT, numTouched INTEGER Each time I update a record I'd like to increment its 'numTouched' column. I could read the record, retrieve the numTouched value, increment it by 1, then update the record with the new text and touched values. Is there a way to do that without SELECT(ing) first the record? Thanks, -- Tito ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] Re: - [sqlite] WHERE expression problem
Try: select count(*) from table1 where (timestamp >13448180261410868 and timestamp <= 13448182164507680); not: select count(*) from table1 where ((timestamp >13448180261410868) and (timestamp <= 13448182164507680)); Regards. rayB ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
[sqlite] Re: - [sqlite] WHERE expression problem
"The second query says that before time A there are 46 entries." No, that is not what the query states: select count(*) from table1 where (timestamp<=13448180261410868); ^ Regards. rayB ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] String to numeric conversion
Please leave the current functionality as is. I believe it is the role of the host language to perform any editing or translation of data, such as the removal of leading or trailing spaces, not the SQL engine. Regards. rayB ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] Auto Increment?
http://www.sqlite.org/lang_createtable.html Regards. rayB |-+> | | Clint Bailey | | | <[EMAIL PROTECTED]| | | h.net> | | || | | 31/01/2006 14:24 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: sqlite-users@sqlite.org | | cc: | | Subject: [sqlite] Auto Increment? | >--| Can you set up a field to auto-increment, and if so how? ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] 2nd question about 'localtime'
Does the column need to be loaded with UTC? Why not just insert the column with localtime already applied? It would make the SELECT you require trivial: SELECT * FROM table WHERE datefield = '2005-12-23'. Regards. rayB |-+> | | "Murray @| | | PlanetThoughtful"| | | >--| | | | To: sqlite-users@sqlite.org | | cc: | | Subject: [sqlite] 2nd question about 'localtime' | >--| Hi All, I have a second question re: dates in SQLite and 'localtime'. I have a table with a DEFAULT CURRENT_TIMESTAMP field. I'm trying to retrieve a recordset of records that have been added to that table today (but, of course, because the field stores UTC, the value for the majority of those records are datetime values for yesterday). In SQLSERVER2K I'm used to retrieving records for a given day by using something like: SELECT * FROM table WHERE datefield BETWEEN '2005-12-23' AND '2005-12-23'; I've experimented with a number of different SQL statements in SQLite to achieve the same result, but nothing (so far) returns records I added with a local date of today (which is '2005-12-23'). Can anyone help me understand how to achieve this in SQLite? Many thanks and much warmth, Murray ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] CURRENT_TIMESTAMP records / displays incorrect value?
Refer http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions. 'localtime' has to be allowed for. Regards. rayB |-+> | | "Murray @| | | PlanetThoughtful"| | | >--| | | | To: sqlite-users@sqlite.org | | cc: | | Subject: [sqlite] CURRENT_TIMESTAMP records / displays incorrect value? | >--| Hello All, New to the list, so please forgive if this has been discussed previously. I have a column defined with DEFAULT CURRENT_TIMESTAMP in an SQLite 3.2.7 db (on WinXP SP2, if that's important). I've noticed that the value being stored in that column is being recorded / displayed incorrectly. For example, it's currently 5:28am 22 Dec 2005 (in Australia, if that causes confusion), and yet a record inserted at this point contains "2005-12-21 19:28:54" when SELECTed back from the table. Is this a known issue? I wondered if there was a time offset setting, but haven't been able to find one in the documentation. Any help appreciated! Much warmth, Murray ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
[sqlite] Re: - [sqlite] can anyone reproduce ticket# 1540 (failure to create a primary key)?
I cannot reproduce the problem. Table is created and accepts insertion of NULL values as expected. However, you do not include semi-colons at the end of the statements your samples - is this of any significance? Regards. rayB ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
RE: [sqlite] CHECK constraints
My information is that MySQL does not enforce check constraints - your testing supports this. Regards. rayB |-+> | | "Marcus Welz"| | | <[EMAIL PROTECTED]| | | om> | | || | | 03/11/2005 11:59 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: | | cc: | | Subject: RE: [sqlite] CHECK constraints | >--| To be honest, I didn't expect that either. I guess with NULL meaning "absence of a value" the logic here is that since it cannot determine the value of NULL, it let's it pass. Why that was chosen over failing the check doesn't make sense to me. MySQL 3.23.58 gives a syntax error on the table definition. MySQL 4.0.24 inserts the record fine -- but it also inserts (5, 4). i.e. it seems to ignore the check altogether. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 7:43 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] CHECK constraints "Marcus Welz" <[EMAIL PROTECTED]> wrote: > PostgreSQL 8.0 will happily insert (5, NULL). > Hmmm.. Not what I expected, nor what I implemented. But the implementation is easily changed and there is no point in trying to be "logical" about the behavior of NULLs, I've learned. I will probably modify SQLite to conform to PostgreSQL unless there is a serious outcry against this, or unless someone learns that PostgreSQL intends to change their behavior... I'm eager to hear what other RDBMSes do. -- D. Richard Hipp <[EMAIL PROTECTED]> ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] SQL Window/OLAP functions
Seconded. |-+> | | "Laurent"| | | <[EMAIL PROTECTED]| | | ternet.fr> | | || | | 12/10/2005 23:36 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: | | cc: | | Subject: Re: [sqlite] SQL Window/OLAP functions | >--| Hello, I was just looking for a statiscal package linked with SQLITE. > > Using SQLite in conjunction with a powerful statistical data analysis > programming language like R is an excellent example of a use where > windowing functions can be hugely helpful. Unfortunately, I've never > had a compelling need to use SQLite for that, otherwise I'd probably > take a shot at adding support for the SQL:2003 Window/OLAP stuff. :) > I can confirm that there would be some interest in having such a library. Best regards, Laurent. == - Original Message - From: "Andrew Piskorski" <[EMAIL PROTECTED]> To: Sent: Wednesday, October 12, 2005 2:34 PM Subject: [sqlite] SQL Window/OLAP functions > On Wed, Oct 12, 2005 at 05:12:05AM -0500, pilot pirx wrote: > > Subject: [sqlite] Please, please do _not_ remove this feature from SQLite... > > > While using SQLite for some time (with R package, www.r-project.org) > > I did admire its functionality and speed. Then I did discover a > > hidden SQLite feature of immense usefulness - not available in other > > databases. SQLite can compute Fibonacci numbers! (I will explain why > > Transaction visibility features do vary, although often it doesn't > matter anyway. E.g., here's a dicussion of how (at least as of early > 2004), PostgreSQL's docs were quite confused about certain subtleties, > but what I find interesting, is this was still something that in > practice had never really mattered to the mostly hard-core RDBMS > programmers talking about it in that thread: > > http://openacs.org/forums/message-view?message_id=176198 > > > UPDATE fib SET > > val = (SELECT h1.val FROM fib as h1 where pos = fib.pos - 1) + > >(SELECT h2.val FROM fib as h2 where pos = fib.pos - 2) > > WHERE pos > 2; > > I don't see why this is such a great feature. Without it, worst case, > you could still write a simple little loop which would issue one > update statement for each row, all within a single transaction. No? > > > This is an _immensely_ useful functionality when one needs to > > compute various recursive functions. For example exponential moving > > average, used frequently in financials. Or Kalman filter (and many > > Vastly more useful for moving average and the like would be real > windowing/grouping functions, like Oracle's "analytic" functions. I'm > not thrilled by their particular syntax, but the functionality is > INCREDIBLY useful. (And on the other hand, I haven't thought of any > obviously better syntax, either.) > > Hm, an amendement to the SQL:1999 spec added windowing support, and > SQL:2003 includes that, I think as features T611, "Elementrary OLAP > functions" and T612, "Advanced OLAP functions". Apparently Fred Zemke > of Oracle was the author of that SQL spec, and IBM also supported it, > so the SQL:2003 syntax and behavior is probably very similar (maybe > identical?) to what Oracle 8i, 9i, and 10g and IBM's DB2 already have. > PostgreSQL, as of 8.0, doesn't support it yet. > > http://www.wintercorp.com/rwintercolumns/SQL_99snewolapfunctions.html > http://www.ncb.ernet.in/education/modules/dbms/SQL99/OLAP-99-154r2.pdf > http://www.wiscorp.com/sql/SQL2003Features.pdf > http://troels.arvin.dk/db/rdbms/#select-limit-offset > http://www.postgresql.org/docs/8.0/interactive/features.html > http://en.wikipedia.org/wiki/SQL > http://www.sigmod.org/sigmod/record/issues/0403/E.JimAndrew-standard.pdf > http://www.oracle.com/oramag/oracle/01-jul/o41industry.html > > SQLite basically supports just SQL-92, it doesn't have any of these > newer SQL:1999 or SQL:2003 features, right? > > Using SQLite in conjunction with a powerful statistical data analysis > programming language like R is an excellent example of a use where > windowing functions can be hugely helpful. Unfortunately, I've never > had a compelling need to use SQLite for that, otherwise I'd probably
[sqlite] Re: - Re: [sqlite] Formatting the strftimeFunc function
... internationalise. Sorry, couldn't resist. |-+> | | [EMAIL PROTECTED]| | || | | 11/10/2005 07:48 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: sqlite-users@sqlite.org | | cc: | | Subject: - Re: [sqlite] Formatting the strftimeFunc function | >--| That is easy enough to do for the english-speaking world. It is hard to internationalize. -- D. Richard Hipp <[EMAIL PROTECTED]> ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
[sqlite] Re: - Re: [sqlite] query problem
No. COUNT(*) of an empty result returns 0. COUNT(*) should always return an integer value, never NULL. It is a row-based, rather than a column-based, aggregate function. rayB |-+> | | "D. Richard Hipp"| | | <[EMAIL PROTECTED]> | | || | | 20/09/2005 05:19 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: sqlite-users@sqlite.org | | cc: | | Subject: - Re: [sqlite] query problem | >--| Hence, the result set contains no rows. A COUNT() of a empty result set gives NULL. -- D. Richard Hipp <[EMAIL PROTECTED]> ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] count(*) slow
... and where will it stop? Someone will then ask for 'SELECT COUNT(*) ... WHERE ...' changes. Agreed, leave things as they are. rayB |-+> | | Darren Duncan| | | <[EMAIL PROTECTED]| | | can.net> | | || | | 16/09/2005 14:19 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: sqlite-users@sqlite.org | | cc: | | Subject: Re: [sqlite] count(*) slow | >--| At 8:56 AM -0500 9/15/05, Puneet Kishor wrote: >Hence, it might be worthwhile maintaining the meta information no >matter what... most of the folks won't ever notice it, and everyone >would marvel at how quickly COUNT(*) was returning the results. You are assuming that everyone wants to do a count(), but many people don't; for them, putting that in the core slows things down; for people that do want it sped up, the trigger option is perfectly valid. I support leaving things the way they are, with no extra meta-info maintained. -- Darren Duncan ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] Did OSCON tutorial get accepted for AUUG in oct?
Is it M6 you are referring to? http://www.auug.org.au/events/2005/auug2005/tutorials.html Regards. rayB |-+> | | Klint Gore | | | <[EMAIL PROTECTED]| | | u> | | || | | 10/08/2005 12:35 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: sqlite-users@sqlite.org | | cc: | | Subject: [sqlite] Did OSCON tutorial get accepted for AUUG in oct? | >--| Anyone know if the OSCON tutorial was accepted for AUUG2005? klint. +---+-+ : Klint Gore: "Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---+-+ ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
[sqlite] Re: - Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
I too would be happy to pay for DVDs if they were to be made available. Tyranny of distance prevents me from attending (Sydney, Australia based). rayB |-+> | | "Paul G" | | | <[EMAIL PROTECTED]| | | rge.com> | | || | | 20/06/2005 10:15 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: | | cc: | | Subject: - Re: [sqlite] Training opportunity: The Inner Workings Of SQLite| >--| - Original Message - From: "Robert L Cochran" <[EMAIL PROTECTED]> To: Sent: Sunday, June 19, 2005 8:19 PM Subject: Re: [sqlite] Training opportunity: The Inner Workings Of SQLite > I'd like to ask about this too. I'd be very happy to pay for DVDs. I'd > like to go to OSCON but the costs involved make it tough for me, > especially with 2 kids in university. ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
[sqlite] Re: - [sqlite] How to do NULL Handling in SELECT Statement?
Try: SELECT * FROM t1 WHERE b IS NULL; A column value is null or not null; it cannot be said to equal null as null has no value; rayB |-+---> | | Stefan Finzel | | | <[EMAIL PROTECTED]| | | -Online.de> | | | | | | 23/03/2005 04:20| | | Please respond to | | | sqlite-users| | | | |-+---> >--| | | | To: sqlite-users@sqlite.org | | cc: | | Subject: - [sqlite] How to do NULL Handling in SELECT Statement? | >--| Hi, what is the correct way to query for NULL-values? I use SQLite version 3.2.0 create table t1(a int, b char); insert into t1 values(1, '2'); insert into t1 values(3,NULL); insert into t1 values(NULL,'4'); select * from t1 where b=NULL; -- this gives no result at all select * from t1 where b=''; -- this also gives no result select * from t1 where b<>''; -- this gives the expected result (but i wanted the reverse data set) 1|2 |4 -- so i tried select * from t1 where not b<>''; -- and still i get not the result i was looking for. TIA Stefan *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] Speeding up your SQLite DB (Windows mostly)
No, thank you for taking the time and effort for this very informative post-mortem. There's some stuff here I didn't know, so my knowledge and skills have also been expanded. Regards. rayB *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] VACUUM question
Just curious. What is it that is motivating you to vacuum so frequently? Regards. rayB *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] How are NULL values deleted?
It's not possible for a column value to be equal to NULL; hence the SQL syntax is 'IS NULL'. However, in an UPDATE statement, writing 'columnA=NULL' is valid, as in this context '=' is an assignment, not a relationship operator. Regards. rayB |-+> | | Tito Ciuro | | | <[EMAIL PROTECTED]> | | || | | 28/10/2004 08:55 | | | AM | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: Forum SQLite <[EMAIL PROTECTED]> | | cc: | | Subject: [sqlite] How are NULL values deleted? | >--| Hello, I'd like to remove all rows with a specific column equaling NULL. I've tried this: SQLite version 3.0.8 Enter ".help" for instructions sqlite> select * from address; Ciuró|1|Javi||España Garaicoechevarria|2|Ana||España Ciuró|3|Tito||España Miti|4|Sam||Italy Schmuck|5|Joe||Germany sqlite> delete from address where ZIP = NULL; sqlite> select * from address; Ciuró|1|Javi||España Garaicoechevarria|2|Ana||España Ciuró|3|Tito||España Miti|4|Sam||Italy Schmuck|5|Joe||Germany sqlite> delete from address where ZIP = 'NULL'; sqlite> select * from address; Ciuró|1|Javi||España Garaicoechevarria|2|Ana||España Ciuró|3|Tito||España Miti|4|Sam||Italy Schmuck|5|Joe||Germany Since all rows have NULL for ZIP, I would expect to remove all rows, but I cannot figure it out... Any ideas? Thanks, -- Tito *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] sqlite.exe binary (windows)
SQLite generating the "create index" SQL DDL statement at the end of the .dump output is the correct behaviour. In my experience using a number of different DBMSs, the sequence of data loading and then indexing is usually quicker than performing those operations the other way round. In a commercial environment, it's not unusual to have tables that contain many millions of rows and have a number of indexes (perhaps 10 or more) associated with them. Inserting a row into such a table becomes almost a trivial exercise for the DBMS compared to work it has to perform to maintain that many indexes for so much data. As is usually the case, those that design and maintain SQLite have probably got it right. Regards. rayB |-+> | | Steven Van | | | Ingelgem | | | <[EMAIL PROTECTED]> | | || | | 09/09/2004 15:12 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: [sqlite] sqlite.exe binary (windows) | >--| I just noticed something rather stupid... when you .dump a table via the sqlite.exe binary (2.8.15)... It dumps first the "create table", then the "insert"s, and afterwards the indexes Now if you have a very big table it will take a LOT of time to place those indexes... Maybe it is more performant to place the "create index" just after the "create table" statement? Greetings, KaReL (aka Steven) Main Webpage : http://www.karels0ft.be/ ICQ # : 35217584 *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
RE: [sqlite] How can i get the column's names from a table with t he sqlite.exe command line ?
Or try: .mode lines .null select * from tablename limit 1; The output is more readable if tablename has many columns and also provides some example data for each column. rayB |-+---> | | "Griggs, Donald"| | | <[EMAIL PROTECTED]| | | thcare.com> | | | | | | 27/08/2004 07:41| | | Please respond to | | | sqlite-users| | | | |-+---> >--| | | | To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> | | cc: | | Subject: RE: [sqlite] How can i get the column's names from a table with t he sqlite.exe command line ? | >--| Subject: [sqlite] How can i get the column's names from a table with the sqlite.exe command line ? Bonjours, Christian. As far as I know, you could either: Parse them from the output of .schema tablename or, more simply, if the table is non-empty: .headers on select * from tablename limit 1; and pay attention to only the first of the two lines of output (the headers) Opinions are not necessarily those of Misys Healthcare Systems nor its board of directors. *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
[sqlite] Re: - [sqlite] Cloudscape?
Windows download is 628.1MB. There goes your hard drive. 'Nuff said really. rayB |-+> | | Andrew Piskorski | | | <[EMAIL PROTECTED]| | | m> | | || | | 04/08/2004 06:26 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: - [sqlite] Cloudscape? | >--| Anyone know much of anything about IBM's Cloudscape database? Advantages or disadvantages vs. SQLite? http://www-306.ibm.com/software/data/cloudscape/ http://www.zdnet.com.au/news/software/0,261733,39155170,00.htm I hadn't heard of it before, so I'm curious. -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com/ *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] Bug with UNION
UNION working correctly. UNION returns distinct values; UNION ALL returns all rows (including duplicates). rayB *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]