Insert row count result into another table

Question

How can I count total rows from different tables and insert them into a column of a result table. In MySQL

Insert into hospitals(total_case)
Select count(*)
Id, count (id)
From Islamabad

here you're fetching 2 column but trying to insert in single column. That would be an issue. — Dark Knight, Sep 18 '20 at 13:18
Does this answer your question? [INSERT with SELECT](https://stackoverflow.com/questions/5391344/insert-with-select) — Kars, Sep 19 '20 at 10:56

score 0 · Answer 1 · answered Sep 18 '20 at 13:19

Number of columns in INSERT INTO statement should match with number of columns selected in SELECT clause.

You have selected two columns count(*) Id, count (id) but want to insert in single column total_case which would create an error.

INSERT INTO hospitals (total_case)
SELECT COUNT(id)
FROM Islamabad;

1 Answers1