mysql 多个表union查询_MySQL:UNION -- 多张表查询出的结果集合并

Demo Code:

CREATE TABLE TABLE1 (

ID1BIGINT(50) PRIMARY KEY,

NAME1varchar(50),

PSW1varchar(50)

);

CREATE TABLE TABLE2 (

ID2BIGINT(50) PRIMARY KEY,

NAME2varchar(50),

PSW2varchar(50)

);

INSERT INTO

TABLE1(ID1, NAME1 ,PSW1)

VALUES(1,'user1','psw1');

INSERT INTO

TABLE2(ID2, NAME2 ,PSW2)

VALUES(2,'user2','psw2');

SELECT T1.ID1 ID_FIELD, T1.NAME1 NAME_FIELD, T1.PSW1 PSW_FIELD

FROM TABLE1 T1

UNION

SELECT T2.ID2 ID_FIELD, T2.NAME2 NAME_FIELD, T2.PSW2 PSW_FIELD

FROM TABLE2 T2;

The Query ResultSet as follows :

ID_FIELD

NAME_FIELD

PSW_FIELD

1

user1

psw1

2

user2

psw2