这句mysql语句有什么错误？

Question

想将 we_event_userinfo 中的 name、time 字段复制到 we_event_active_class 表中，请问下面的sql语句有哪些错误？

---

INSERT INTO `we_event_active_class`
VALUES 
    SELECT `event_name` as `name`, `time` as `create_at`, 0 as `status` 
        FROM `we_event_userinfo`
        GROUP BY `event_name` 
        ORDER BY `time`

---

we_event_active_class 结构

---

we_event_userinfo 数据

Answer 1

如果两个表中字段个数不同

INSERT INTO we_event_active_class(?,?,?) #请分别指定对应字段