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
    What's not workign?
  2. fenway
    Not easily -- that's why comma-separated lists are a bad idea.
  3. fenway
    Those look like custom functions -- are you sure they are present in your database?
  4. fenway
    Sorry, what's the outstanding issue?
  5. fenway
    Besides, exact values for pagination is just slow -- Google doesn't do it, either.
  6. fenway
    This has nothing to do with mysql.
  7. fenway
    The delimited list is only appropriate for summary tables.
  8. fenway
    Don't use these values as counters -- that's just wrong. Nothing will work properly if you reset them. Trust me.
  9. fenway

    MySQL Where IN

    fenway replied to rawrzz's topic in MySQL Help

    MySQL will return the rows that match ANY of those values. Why do you want it 3 times?
  10. fenway
    Cleanest, yes; fastest, no. The most efficient way to is to self-join N times -- as long as N is small.
  11. fenway
    In general, use case-insensitive collations -- no performance hit.
  12. fenway
    Echo the query.
  13. fenway
    Drop the joins, get the desired grouped result first, then join.
  14. fenway
    Correct.
  15. fenway
    Good -- now post the output you get from each one, and what you want instead.
  16. fenway
    Store this as min/max values, with a text label.
  17. fenway
    That's because you can't mix JOINs and GROUP BY that way -- and you can't rely on any non-aggregated columns, either.
  18. fenway
    Yup, this is caching -- no reason to post the script in the mysql forum.
  19. fenway
    Don't mark your posts with "urgent" -- it's against the ToS. And besides, I don't see a question.
  20. fenway
    The table prefixes are not included -- use an explicit column alias.
  21. fenway
    Don't build the query, build the clauses -- push onto an array, join at the end.
  22. fenway
    If you really wanted, you could look up the index column in mysql's table, but it seems like a bother.
  23. fenway
    Don't generate users or view on-the-fly -- that's not a good approach.
  24. fenway
    You don't get a choice -- specify them -- typing is easy.
  25. fenway
    I'm not sure what you want us to do with that statement.
×
×
  • 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.