Jump to content

fenway

Staff Alumni
  • Posts

    16,168
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by fenway

  1. I have a hard time believe that mysql is lying.
  2. Well, you can always run a scalar subquery on the final set just to get the counts, I suppose.
  3. If you're asking if adding new columns to a random table can hurt anything in code that you wrote, the answer is no
  4. fenway

    Mysql Error...

    I don't have any idea what that means. How about sharing the error and the actual query?
  5. Also, the entire point on FKs is that you can't delete certain things by accident.
  6. That's because you're using GROUP BY -- and you don't need to. And that's not joining to the table to itself. Don't have time at the moment to write the query for you, though.
  7. What doesn't work about it???
  8. Ok -- then simply join the table to itself and filter on the earliest time, with a where clause.
  9. And next time, use mysql_error().
  10. So you want the query to return on the first entry for each person?
  11. Depends what server/OS you're runnign.
  12. That's the correct choice
  13. That's not mysql's job -- use php for this.
  14. According to what? Did you execute ANALYZE TABLE?
  15. Sounds like you're talking about a SET.
  16. Then get all of the series, and join to a random row of picture for each one.
  17. Well, you can't use expressions as default values, hence the error. By why not just change the server time zone? Or, at the very least, change the session's timezone to compensate?
  18. Then echo the query
  19. What does this actually mean???
  20. If these are TIMESTAMP columns, you can use mysql's built-in timezone features.
  21. So either 2 or 3 results in "true"? A specific 2, or any 2?
×
×
  • 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.