Jump to content

fenway

Staff Alumni
 View Profile  See their activity

  • Posts

    16,168

  • Joined

  • Last visited

  • Days Won

    4

 Content Type 

Everything posted by fenway

  1. fenway
    Post the table structure, and the query.
  2. fenway
    Why are you running this query? Is this a one-off DB cleanup? Otherwise, don't store the same value in 2 places.
  3. fenway
    What are you trying to achieve?
  4. fenway
    Then I don't understand what you're asking.
  5. fenway
    DESCRIBE will work too, pre v5.
  6. fenway
    This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=344334.0
  7. fenway
    That's just lazy -- that's what loops are for. In the time you spent "googling all day", you could have been done 30 times.
  8. fenway
    You mean like "parent_uid"?
  9. fenway
    Don't bump a thread twice in one day, let alone twice in 30 minutes.
  10. fenway
    Sorry, I'm not windows IT guy -- I'm knowledgeable, but not about a system that I can't sit in front of.
  11. fenway
    If you don't know, how can we?
  12. fenway
    That means you have parallel arrays -- that's what a hash is for.
  13. fenway
    Clicking links has nothing to do with mysql.
  14. fenway
    What?
  15. fenway
    Never change an auto-incremented value -- EVER.
  16. fenway

    query optimization

    fenway replied to jd22's topic in MySQL Help

    Explain that distinct requirement again...?
  17. fenway
    Usually a "run as administrator" game.
  18. fenway
    Yes, that's still an issue.
  19. fenway
    Better == Pythagoras.
  20. fenway
    Yup, just missing the actual INSERT.
  21. fenway
    You need HAVING -- and don't use great circle distance -- it's just unnecessarily slow.
  22. fenway
    That's usually a windows user account permission game.
  23. fenway

    query optimization

    fenway replied to jd22's topic in MySQL Help

    It's not optimized because you're not using JOINs.
  24. fenway
    As listed, KEY is just a plain old index -- no "constraint" of any type.
  25. fenway
    ...Did you miss the scrollbars? No, I didn't -- that's not SQL, that's PHP.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.