Mysql创建视图：
CREATE VIEW all_users AS
SELECT id, name, age, create_time FROM table1
UNION ALL
SELECT id, name, age, create_time FROM table2
UNION ALL
SELECT id, name, age, create_time FROM table3;

Navicat中的视图定义一般只用写：
SELECT id, name, age, create_time FROM table1
UNION ALL
SELECT id, name, age, create_time FROM table2
UNION ALL
SELECT id, name, age, create_time FROM table3;