...
Now - would searching, saving/storing then removing NULL vs ALLbutNULL
in a simple DB with one table wich has only primary key be sa
...
What is "removing NULL"? Deleting the record with NULL?
It has no bearing on the primary key, because NULL never is allowed in one.
It seems to me that r
- Original Message -
> From: "lejeczek"
> Subject: Re: find any row with NULL
> ok, whereas that fist example was about all (and find
> columns' names without knowing) columns - would there be a
> simple(r) syntax to find that (not)NULLs in a list of give
- Original Message -
> From: "lejeczek"
> Subject: Re: find any row with NULL
>
> shame NULL won't work as in:
> > select user_id,completetion_time from depression where
> NULL in(email_me, other_diagnosis);
> or does it?
No, because NULL
On 09/07/16 14:13, Hal.sz S.ndor wrote:
2016/07/08 09:15 ... Johan De Meersman:
You will have to repeat all the column names - no
wildcards in where clause fieldnames - but the clause
you're looking for is WHERE field IS NULL. Or IS NOT NULL
if you want those:-)
Well, one could try this:
s
- Original Message -
> From: "Sándor Halász"
> Subject: Re: find any row with NULL
>
> from information_schema.columns where (table_schema, table_name,
You could, but information_schema queries can get pretty slow on large
databases, especially so with InnoDB. R
2016/07/08 09:15 ... Johan De Meersman:
You will have to repeat all the column names - no wildcards in where clause
fieldnames - but the clause you're looking for is WHERE field IS NULL. Or IS
NOT NULL if you want those:-)
Well, one could try this:
set @sel=(select 'SELECT ' || GROUP_CONCAT(c
On 7/8/2016 9:15 AM, Johan De Meersman wrote:
As a clear example of what it is useful for, imagine a situation where you're
performing an inventory on an existing warehouse. You have the
list of all the
products they've ever sold, but you need to differentiate between
'this product is
not in s
'I have not counted this product yet' (count
IS NULL).
/Johan
- Original Message -
> From: "lejeczek"
> To: "MySql"
> Sent: Friday, 8 July, 2016 14:27:45
> Subject: find any row with NULL
> hi there,
>
> I've been searching the va
hi there,
I've been searching the vastness of the net but cannot find
- how - to get all the rows with a NULL.
And like any novice I wonder if this can be done without
reiterating all the columns names(not manually at least)?
Some expert would say it is easy, how easy is it? with an
examp