From ed011383b14ac5340653cb7cbca569ba237e8d6c Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Mon, 3 Apr 2023 11:33:27 +0300 Subject: Update query for demo'ing rows with an empty symbol Signed-off-by: Munyoki Kilyungi --- issues/dump-genewiki-metadata.gmi | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/issues/dump-genewiki-metadata.gmi b/issues/dump-genewiki-metadata.gmi index 37786b6..b727e26 100644 --- a/issues/dump-genewiki-metadata.gmi +++ b/issues/dump-genewiki-metadata.gmi @@ -62,8 +62,9 @@ SELECT * FROM GeneRIF_BASIC WHERE symbol = 'NEWENTRY'\G ("–" . "-")) ``` -* In the GeneRIF_BASIC table, there are rows with an empty symbol (empty string instead of NULL): +* In the GeneRIF_BASIC table, there are 14,313 rows with an empty symbol: + ``` -SELECT * FROM GeneRIF_BASIC WHERE TaxID=139 AND GeneId = 13917590 AND PubMed_ID = 23692497\G +SELECT COUNT(*) FROM GeneRIF_BASIC WHERE symbol = ''; ``` -- cgit v1.2.3