表1:employees
表2:message_state
表3:t_message
INSERT INTO message_state (mid,eid,state) SELECT t_message.id as id,employees.eid as eid,0 as state from t_message JOIN employees;
注意:查询结果的列名要和插入的列名一致
表1:employees
表2:message_state
表3:t_message
INSERT INTO message_state (mid,eid,state) SELECT t_message.id as id,employees.eid as eid,0 as state from t_message JOIN employees;
注意:查询结果的列名要和插入的列名一致