mysql - 从一个表中获取所有 ID，并根据它在另一表中插入值

Question

我有两个表:

表 1:公司(ID、名称)表 2:假期(id、companyId、name)

目前公司表有数据，但假期没有数据。我想遍历所有公司，获取他们的 ID，并在每家公司的假期中插入两条记录。所以这将是之前和之后:

之前:

Companies
| id | name  |
|  0 | test1 |
|  1 | test2 |

假期:空表

之后:

Companies
| id | name  |
|  0 | test1 |
|  1 | test2 |

Holidays:
| id | companyId | name     | 
|  0 |         0 | holiday1 |
|  1 |         0 | holiday2 |
|  2 |         1 | holiday1 |
|  3 |         1 | holiday2 |

Answer 1

假设Holidays.id设置为自动递增:

insert into Holidays (select id as companyId, 'holiday1' as name from Companies);
insert into Holidays (select id as companyId, 'holiday2' as name from Companies);