MySQL: Lasy UNION

標籤：

Method 1:

From book <高效能MySQL>

select greatest(@found := -1, user_id) as user_id, ‘user‘ as which_tbl   from user where user_id = 1union allselect user_id as user_id, ‘user_archive‘ as which_tbl   from user_archive where user_id = 1 and @found is nullunion allselect 1, ‘‘ from dual where ( @found := null ) is not null;

Method 2: I voted this....

http://stackoverflow.com/questions/3202242/mysql-if-a-select-query-returns-0-rows-then-another-select-query

SELECT SQL_CALC_FOUND_ROWS *FROM mytableWHERE x = 1UNION ALLSELECT *FROM mytableWHERE FOUND_ROWS() = 0 AND x = 1;

　　Method 3:

SELECT * FROM mytable WHERE x = 1UNIONSELECT * FROM mytable2 WHERE x = 1 AND NOT EXISTS (SELECT * FROM mytable WHERE x = 1);

　　

MySQL: Lasy UNION