[CWB] problems with corpus word count

[Benedikt Singpiel]

Hello Andrew,

Now I got it! Here are my values:


mysql> select count(*) from freq_corpus_pilot_word;
+----------+
| count(*) |
+----------+
|    37250 |
+----------+
1 row in set (0.14 sec)

mysql> select sum(freq) from freq_corpus_pilot_word;
+-----------+
| sum(freq) |
+-----------+
|    458874 |
+-----------+
1 row in set (0.07 sec)

mysql> select size_types, size_tokens, size_texts from corpus_info  
where corpus = "PILOT";
+------------+-------------+------------+
| size_types | size_tokens | size_texts |
+------------+-------------+------------+
|      37250 |           4 |          4 |
+------------+-------------+------------+

Frequency tables seem complete, corpus log isn't.


best

Benedikt


> ------------------------------
>
> Message: 3
> Date: Tue, 17 May 2016 12:16:11 +0000
> From: "Hardie, Andrew" <a.hardie at lancaster.ac.uk>
> To: Open source development of the Corpus WorkBench
> 	<cwb at sslmit.unibo.it>
> Subject: Re: [CWB] problems with lemma query and corpus word count
> Message-ID:
> 	<28078EC3FBF1B940A3EF3D0D19BE351D7FB3DA97 at EX-0-MB1.lancs.local>
> Content-Type: text/plain; charset="utf-8"
>
> You have to select the database first.
>
> http://dev.mysql.com/doc/refman/5.7/en/use.html
>
> best
>
> Andrew.
>
> -----Original Message-----
> From: cwb-bounces at sslmit.unibo.it  
> [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Benedikt Singpiel
> Sent: 17 May 2016 13:15
> To: cwb at sslmit.unibo.it
> Subject: [CWB] problems with lemma query and corpus word count