mysql一行数据分成两行

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    phone1 VARCHAR(15),
    phone2 VARCHAR(15)
);

CREATE TABLE user_phones (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    phone VARCHAR(15),
    FOREIGN KEY (user_id) REFERENCES users(id)
);

INSERT INTO user_phones (user_id, phone)
SELECT id, phone1 FROM users WHERE phone1 IS NOT NULL;

INSERT INTO user_phones (user_id, phone)
SELECT id, phone2 FROM users WHERE phone2 IS NOT NULL;

ALTER TABLE users RENAME TO users_old;

INSERT INTO user_phones (user_id, phone)
SELECT id, phone1 FROM users WHERE phone1 IS NOT NULL AND phone1 REGEXP '^[0-9]{10,15}$';

INSERT INTO user_phones (user_id, phone)
SELECT id, phone2 FROM users WHERE phone2 IS NOT NULL AND phone2 REGEXP '^[0-9]{10,15}$';