mysql语句SELECT INSERT INTO tip

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;;

我的insert My (rss)如下所示：

  id  hashtag  total
  1    null    55
  2    null    22

Answer 1

如果数据类型和示例sql等都是正确的(并且select返回了一个hashtag )，那么下面的操作应该是有效的(删除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;

Answer 2

插入的字段数应与INSERT INTO table_name (field list)中指定的字段数匹配

INSERT INTO rss (hashtag,total)
SELECT
  hashtag,
  SUM(count) AS total