Sequence of dates - months from January to December with SQL
If you are using MariaDB, use something like this:

SELECT '2015-01-01' + INTERVAL seq MONTH FROM seq_0_to_11;


More discussion:  https://mariadb.com/kb/en/library/sequence-storage-engine/