MySQL stats, what would be better?

There is a table with thousands of lines of the form:
01.02.2015 | Dima, Sasha, Roma, Masha, Kat, Dima, Dima
02.02.2015 | Sasha, Bob, Jame, Pol, Masha
03.02.2015 | Dima, Masha, Oliver, Masha, Masha, Masha
04.02.2015 | Dima, Mike, Denis

There is a table with the standard names:
names | pam, Roma, Dima, Sasha

I need to build a new table that would contain information about what day how many times met what name.

Working with MySQL. Does it have some kind of Analytics. Without a separate programming language it can be done by means of the DBMS?
September 19th 19 at 00:16
1 answer
September 19th 19 at 00:18
Can Notepad without human intervention populated with data?
SQL is just a text file, and mysql is a set of commands for modifying that file.
Put Python and write it on the script if I don't want to be bothered.

Find more questions by tags AnalystMySQL