用mysql实现Codeigniter中的“create view”和"Other query“合并问题

CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;

$this->db->query('CREATE VIEW view_name AS SELECT column1, column2 FROM table_name WHERE condition');

SELECT column1, column2, ...
FROM table1
WHERE condition
UNION
SELECT column1, column2, ...
FROM table2
WHERE condition;

SELECT column1, column2, ...
FROM table1
WHERE condition
UNION ALL
SELECT column1, column2, ...
FROM table2
WHERE condition;

$query1 = $this->db->query('SELECT column1, column2 FROM table1 WHERE condition');
$query2 = $this->db->query('SELECT column1, column2 FROM table2 WHERE condition');
$result = $query1->result();
$result = array_merge($result, $query2->result());