diff options
| author | Munyoki Kilyungi | 2023-04-03 11:33:27 +0300 |
|---|---|---|
| committer | Munyoki Kilyungi | 2023-04-03 11:33:27 +0300 |
| commit | ed011383b14ac5340653cb7cbca569ba237e8d6c (patch) | |
| tree | 7b78259ee52a7b87eec6cb6cec1a0dde73655784 /issues/dump-genewiki-metadata.gmi | |
| parent | 81ad6cb2a0d0cff9aa4d8c8a698ed08fdf4f67a7 (diff) | |
| download | gn-gemtext-ed011383b14ac5340653cb7cbca569ba237e8d6c.tar.gz | |
Update query for demo'ing rows with an empty symbol
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'issues/dump-genewiki-metadata.gmi')
| -rw-r--r-- | issues/dump-genewiki-metadata.gmi | 5 |
1 files 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 = ''; ``` |