1. Create table tb0(id INT NOT NULL, name VARCHAR(50) NOT NULL,age INT NOT NULL,company VARCHAR(50) NOT NULL,gender VARCHAR(10) NOT NULL,primary key(id)) ENGINE = InnoDB DEFAULT CHARSET = utf8MB4;
2. Create table tb2(id INT NOT NULL, name VARCHAR(50) NOT NULL,gender VARCHAR(10) NOT NULL,primary key(id)) ENGINE = InnoDB DEFAULT CHARSET = utf8MB4;
3. Create table tb3(id INT NOT NULL, name VARCHAR(50) NOT NULL,address VARCHAR(100) NOT NULL,primary key(id)) ENGINE = InnoDB DEFAULT CHARSET = utf8MB4;
'Union' can be used multiple times in an SQL query :