Problem with year in date

Databases
1

Hello guys.
I need your help.

I have in dotable MySQL a list of records; unfortunately the records with year of reg_date 2000, 2001 and 2002 are incomplete and I don’t have chance of a recovery data:

mysql> SELECT
	IFNULL(YEAR, 'Tot') AS YEAR,
	k
FROM
	(
		SELECT
			YEAR (reg_date) AS YEAR,
			COUNT(*) AS k
		FROM
			`doTable`
		GROUP BY
			YEAR WITH ROLLUP
	) x;
+------+------+
| YEAR | k    |
+------+------+
| Tot  | 2984 |
| 2000 |    1 |
| 2001 |    1 |
| 2003 |  364 |
| 2004 |  401 |
| 2005 |  217 |
| 2006 |  135 |
| 2007 |  143 |
| 2008 |  225 |
| 2009 |  261 |
| 2010 |  393 |
| 2011 |  363 |
| 2012 |  262 |
| 2013 |   50 |
| Tot  | 5800 |
+------+------+
15 rows in set

I need distribute this 2986 rows for three years incomplete, e.g.:

+------+------+
| YEAR | k    |
+------+------+
| 2000 | 2000 |
| 2001 |  900 |
| 2002 |   86 |
| 2003 |  364 |
| 2004 |  401 |
| 2005 |  217 |
| 2006 |  135 |
| 2007 |  143 |
| 2008 |  225 |
| 2009 |  261 |
| 2010 |  393 |
| 2011 |  363 |
| 2012 |  262 |
| 2013 |   50 |
| Tot  | 5800 |
+------+------+
15 rows in set

Do you have any suggestion for resolve this problem?
Cheers.

2

if you mean “distribute” them to other years?

do that in php, please

there’s no way that you’re going to easily write sql that distributes 1,999 rows to 2000 and 899 rows to 2001

3

I understand, thank you.