MySQL 查询配合 增 删 改 （笔记）

根据条件查询出来再新增到另一张表

INSERT INTO user_group ( created_at, updated_at, discount, `name`, user_id ) SELECT
`user`.created_at,
`user`.updated_at,
`user`.salt,
`user`.username,
`user`.id 
FROM
	`user` 
WHERE
	`user`.id > 2;

根据条件查询出来再删除对应数据

DELETE ug 
FROM
	`user` u,
	`user_group` ug 
WHERE
	u.id = ug.user_id

根据条件查询出来再修改对应数据

UPDATE user_group ug
INNER JOIN ( SELECT u.updated_at AS updated_at, u.username AS username, u.id AS id FROM `user` u ) AS t ON ug.user_id = t.id 
SET ug.`name` = t.id,
ug.created_at = t.id,
ug.updated_at = t.id,
ug.discount = t.id;