init.sql

DROP TABLE IF EXISTS users;
CREATE TABLE users
(
    id        bigint AUTO_INCREMENT PRIMARY KEY,
    nick_name varchar(20)
);

CREATE TABLE users2
(
    id        bigint AUTO_INCREMENT PRIMARY KEY,
    nick_name varchar(20)
);


TRUNCATE TABLE users;
INSERT INTO users(nick_name)
VALUES ('aja'),
       ('bk'),
       ('afk');


INSERT INTO users2
SELECT id, nick_name
FROM users
WHERE id = 1
UNION
SELECT id, nick_name
FROM users
WHERE id = 2;


SELECT *
FROM users2;