在mysql里 驱动表必须定义别名,不然报错,如下查询格式:
select * from (
select * from tablename union
select * from tablename ) m
where .......
在上面的这个查询里,红色部分外必须定义表别名m ,不然就报错,[Err] 1248 - Every derived table must have its own alias。