mysql语句SELECT INSERT INTO提示

Question

我的语句缺少一列是正确的，但它没有根据顺序将主题标签从表 trending_topics 插入到 rss 表中。

任何调整都可以帮助我的陈述。

INSERT INTO rss (id,hashtag,total)
SELECT
  hashtag,
  SUM(count) AS total
FROM `trending_topics`
WHERE lang=0
  AND hashtag !=     ''
  AND date >= date_sub(left(now(), 10), interval 1 day)
GROUP BY hashtag order by total desc;;

我插入表(rss)的内容如下:

  id  hashtag  total
  1    null    55
  2    null    22

Answer 1

如果数据类型和示例 sql 等正确(并且选择返回了主题标签)，则以下操作应该有效(删除 insert into 语句中的 id)

INSERT INTO rss (hashtag,total)
SELECT
  hashtag,
  SUM(count) AS total
FROM `trending_topics`
WHERE lang=0
  AND hashtag !=     ''
  AND date >= date_sub(left(now(), 10), interval 1 day)
GROUP BY hashtag order by total desc;