MySQL statistics, how best to do?

Question

MySQL

There is a table with several thousand rows of the form:
02/01/2015 | Dima, Sasha, Roma, Masha, Kat, Dima, Dima
02.02.2015 | Sasha, Bob, Jame, Pol, Masha February 3, 2015
| Dima, Masha, Oliver, Masha, Masha, Masha
02/04/2015 | Dima, Mike, Denis
There is a table with reference names:
names | Masha, Roma, Dima, Sasha
I need to build a new table that would contain information on which day, how many times which name occurred.
I work with MySQL. Does it have any analytics tools. Without a separate programming language, can this be done using the DBMS itself?

Answer 1

Can a notebook be filled with data without human intervention?
SQL is just a text file and mysql is a set of commands to modify this file.
Install a python and write a script on it if you don't want to worry too much.