mysql - 在同一查询中选择和插入查询记录

Question

SELECT user_id, description, SUM( Credit ) AS cre, SUM( debit ) AS deb, 
CASE WHEN credit > debit
THEN SUM( credit - debit ) 
END AS del, price, created
FROM accounts
WHERE created
BETWEEN  '2013-11-04'
AND  '2013-11-11'
AND description LIKE  '%Amount Earned%'
OR description =  'S'
OR description =  'B'
GROUP BY user_id

1. 此查询的问题在于此查询是根据 accounts 表中的 user_id 选择所有记录。我想选择仅创建的记录在 '2013-11-04' 之间AND '2013-11-11'
2. 我想选择这些记录并且需要在同一个查询中也插入记录

要求:我想从上周分组的帐户表中按 user_id、Sum(Debit) 和 SUM(Credit) 选择记录，然后 Del ->(credit - debit) 将 Sum 和 Insert 记录放在同一个帐户表中。

Answer 1

insert into (other table ) 
  SELECT user_id, description, SUM( Credit ) AS cre, SUM( debit ) AS deb, 
     CASE WHEN credit > debit
     THEN SUM( credit - debit ) 
  END AS del, price, created
FROM accounts
WHERE 
( created BETWEEN  '2013-11-04' AND  '2013-11-11' )
AND
( description LIKE  '%Amount Earned%'
  OR description =  'S'
  OR description =  'B' )
GROUP BY user_id, created