mysql - 基于子查询向 MySQL 插入大量行......遇到麻烦

Question

所以，我想做的是为表中存在的每个国家/地区插入一行 NONE, $country 。

它应该看起来像

   Afghanistan, NONE
   Albania, NONE
   Andorra, None

...也就是说，除了为每个国家列出的省份之外......它们看起来像这样:

| Zambia                    | Western                                            |
| Zimbabwe                  | Bulawayo                                           |
| Zimbabwe                  | Harare                                             |
| Zimbabwe                  | Manicaland                                         |
| Zimbabwe                  | Mashonaland Central                                |
| Zimbabwe                  | Mashonaland East                                   |
| Zimbabwe                  | Mashonaland West                                   |
| Zimbabwe                  | Masvingo                                           |
| Zimbabwe                  | Matabeleland North                                 |
| Zimbabwe                  | Matabeleland South                                 |
| Zimbabwe                  | Midlands  

这是我正在尝试的代码，但惨遭失败。

insert into countries2 (province,country) 
VALUES ('NONE', (select distinct country from countries2));

我刚刚得到

您无法在 FROM 子句中指定要更新的目标表“countries2”

但它也抛出错误:

Subquery returns more than 1 row

Answer 1

insert into countries2 (province,country) 
 select distinct 'NONE', country from countries2

您可能想检查字段的顺序!