用一个表中的行填充另一个表中的列。基于标准

CREATE TABLE 表A (
  id INT PRIMARY KEY,
  name VARCHAR(50),
  age INT
);

CREATE TABLE 表B (
  col1 VARCHAR(50),
  col2 VARCHAR(50),
  col3 VARCHAR(50)
);

INSERT INTO 表A (id, name, age) VALUES
(1, 'John', 25),
(2, 'Amy', 30),
(3, 'Tom', 35);

INSERT INTO 表B (col1, col2, col3)
SELECT name, age, NULL FROM 表A WHERE id = 1
UNION ALL
SELECT NULL, name, age FROM 表A WHERE id = 2
UNION ALL
SELECT age, NULL, name FROM 表A WHERE id = 3;

+------+------+------+
| col1 | col2 | col3 |
+------+------+------+
| John | NULL | NULL |
| NULL | Amy  | NULL |
| NULL | NULL | Tom  |
+------+------+------+