Advertisement
Guest User

Untitled

a guest
Jul 16th, 2014
282
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.04 KB | None | 0 0
  1. mysql> select version();
  2. +-----------+
  3. | version() |
  4. +-----------+
  5. | 5.1.73    |
  6. +-----------+
  7. 1 row in set (0.00 sec)
  8.  
  9. mysql> EXPLAIN SELECT * FROM mytable JOIN table1 on (table1.id,table1.aid) = (mytable.id, mytable.exchange_id);
  10. +----+-------------+---------+--------+------------------------+---------+---------+--------------------------------+------+-------+
  11. | id | select_type | table   | type   | possible_keys          | key     | key_len | ref                            | rows | Extra |
  12. +----+-------------+---------+--------+------------------------+---------+---------+--------------------------------+------+-------+
  13. |  1 | SIMPLE      | table1  | ALL    | PRIMARY                | NULL    | NULL    | NULL                           |    6 |       |
  14. |  1 | SIMPLE      | mytable | eq_ref | PRIMARY,exchange_id,id | PRIMARY | 8       | test.table1.id,test.table1.aid |    1 |       |
  15. +----+-------------+---------+--------+------------------------+---------+---------+--------------------------------+------+-------+
  16. 2 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement