SHARE
TWEET

Untitled

a guest Jan 12th, 2017 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. EXPLAIN
  2. (select c1 from t1 group by c1,c2 order by c1 limit 1);
  3. id  select_type table   type    possible_keys   key key_len ref rows    Extra
  4. 1   SIMPLE  t1  ALL NULL    NULL    NULL    NULL    2   Using filesort
  5. EXPLAIN
  6. select (select c1 from t1 group by c1,c2 order by c1 limit 1) as x;
  7. id  select_type table   type    possible_keys   key key_len ref rows    Extra
  8. 1   PRIMARY NULL    NULL    NULL    NULL    NULL    NULL    NULL    No tables used
  9. 2   SUBQUERY    t1  ALL NULL    NULL    NULL    NULL    2
RAW Paste Data
Pastebin PRO Summer Special!
Get 40% OFF on Pastebin PRO accounts!
Top