INSERT INTO `table1` (
`id`,
`month`,
`num`,
`addtime`
)
SELECT
uuid() as id,
'2020-02' as month,
count(1) AS num,
now() addtime
FROM
table2
INSERT INTO `table1` (
`id`,
`month`,
`num`,
`addtime`
)
SELECT
uuid() as id,
'2020-02' as month,
count(1) AS num,
now() addtime
FROM
table2