Quote
1. WHERE x.year_c-y.year_c BETWEEN 0 AND 4
AND x.year_c = [value]
2. WHERE x.year_c-y.year_c BETWEEN 0 AND 4
AND x.year_c >= [value]
3. WHERE x.year_c-y.year_c BETWEEN 0 AND 4
AND x.year_c BETWEEN [value AND [value]
But none are correct.
Incorrect how?
> innodb_buffer_pool_size | 268435456
Absurdly low, you have a poor man's shared hosting setup, good only for toy databases, wildly inadequate for what you're trying to do. Let's see the result of ...
select
concat(round(sum(table_rows)/1000000,2),'m') rows,
concat(round(sum(data_length)/(1024*1024*1024),2),'g') data,
concat(round(sum(index_length)/(1024*1024*1024),2),'g') idx,
concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'g') total_size,
round(sum(index_length)/sum(data_length),2) idxfrac
from information_schema.tables
where table_schema='YOUR DB NAME HERE';
Edited 2 time(s). Last edit at 10/03/2017 02:59PM by Peter Brawley.