Using sqlite3 python and I have a problem running a query.
My table has null values. Now if I do a 'select * from tablename' returns
to me as the result:
[(datetime.date (2012, 3, 22), buffer ptr read-write 0x03774B90,
0x03774B58 at size 0, None, None, None, None, None, None)]
As
select * from tablename where field1 IS Null
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Fabio Spadaro
Sent: Thursday, March 22, 2012 11:33 AM
To: General Discussion of SQLite Database
Subject: [sqlite] select null
On 3/22/2012 11:32 AM, Fabio Spadaro wrote:
If I want to run a query like select * from tablename where field1 = Null
select * from tablename where field1 is null;
NULL is never equal any value, not even another NULL.
--
Igor Tandetnik
___
On 22 Mar 2012, at 3:41pm, Igor Tandetnik itandet...@mvps.org wrote:
On 3/22/2012 11:32 AM, Fabio Spadaro wrote:
If I want to run a query like select * from tablename where field1 = Null
select * from tablename where field1 is null;
NULL is never equal any value, not even another NULL.
On 22 mars 2012, at 16:41, Igor Tandetnik wrote:
On 3/22/2012 11:32 AM, Fabio Spadaro wrote:
If I want to run a query like select * from tablename where field1 = Null
select * from tablename where field1 is null;
NULL is never equal any value, not even another NULL.
--
Igor Tandetnik
On 3/22/2012 12:18 PM, Jean-Denis MUYS wrote:
On 22 mars 2012, at 16:41, Igor Tandetnik wrote:
On 3/22/2012 11:32 AM, Fabio Spadaro wrote:
If I want to run a query like select * from tablename where field1 = Null
select * from tablename where field1 is null;
NULL is never equal any value,
I did show this very example, except lacking the whitespace in front
and differing in capitalization. I assume you feel those distinct
characteristics render your example more interesting than mine.
Or mine, which was sent minutes before Igor's. Hmph. ;)
On 22 mars 2012, at 17:26, Igor Tandetnik wrote:
On 3/22/2012 12:18 PM, Jean-Denis MUYS wrote:
On 22 mars 2012, at 16:41, Igor Tandetnik wrote:
On 3/22/2012 11:32 AM, Fabio Spadaro wrote:
If I want to run a query like select * from tablename where field1 = Null
select * from tablename
On 22 March, Jean-Denis wrote:
On 22 mars 2012, at 17:26, Igor Tandetnik wrote:
On 3/22/2012 12:18 PM, Jean-Denis MUYS wrote:
On 22 mars 2012, at 16:41, Igor Tandetnik wrote:
On 3/22/2012 11:32 AM, Fabio Spadaro wrote:
If I want to run a query like select * from tablename where field1 =