6,129
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO attence (a_type,a_starttime,a_endtime,a_reason,a_place,u_id)VALUES (2,'2016-10-20 10:21:54','2016-10-20 10:21:54','运维系统','上海',22669)
INSERT INTO a (a_type,a_starttime,a_endtime,a_reason,a_place,u_id)VALUES (2,'2016-10-20 10:21:54','2016-10-20 10:21:54','运维系统','上海',22669)
-- 把 select 前面的 ( 去掉,
INSERT INTO a
SELECT a.`a_type`,a.`a_starttime`,a.`a_endtime`,a.`a_reason`,a.`a_place`,a.`u_id`
FROM users u
INNER JOIN attence a ON(u.`u_id` = a.`u_id`)
WHERE u.`u_id`=22669