Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    18

    Unanswered: who can tell me why?why i can't query two table

    i have explain my select sql as follows:
    explain select * from a, b where a.reporttime = b.reporttime;
    table type possible_keys key key_len ref rows extra
    b all reporttime null null null 170943
    a ref reporttime reporttime 8 b.reporttime 303
    when i execute" explain select * from a, b where a.reporttime = b.reporttime" my pc will die.
    and actually b table has more data than 303 rows.reporttime has been indexed .who can tell me why?

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: who can tell me why?why i can't query two table

    Originally posted by feelfly
    i have explain my select sql as follows:
    explain select * from a, b where a.reporttime = b.reporttime;
    table type possible_keys key key_len ref rows extra
    b all reporttime null null null 170943
    a ref reporttime reporttime 8 b.reporttime 303
    when i execute" explain select * from a, b where a.reporttime = b.reporttime" my pc will die.
    and actually b table has more data than 303 rows.reporttime has been indexed .who can tell me why?
    No OS, no version of MySQL etc. and my crystal ball is broken

  3. #3
    Join Date
    Dec 2003
    Posts
    18
    win2000+mysql4.016

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •