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
    Well, since this is for a class, I presume you know some basic sql...
  2. fenway
    Sure you can... use LEFT JOIN.
  3. fenway
    You can use a LEFT JOIN or an EXISTS query.
  4. fenway
    VARCHAR goes up to 65K.
  5. fenway
    You can use LEFT()...
  6. fenway
    They're null because there is not matching event_id in this table... that's what you asked it to do.
  7. fenway
    Your real problem is that you're storing a list. Change your DB structure... but for now, use FIND_IN_SET, not a REGEXP.
  8. fenway
    You can store any character in mysql, as long as it is escaped properly.l
  9. fenway
    I'm not sure I understand.
  10. fenway

    Scaling

    fenway replied to waynew's topic in MySQL Help

    Impossible to guess based on info provided... but yes.
  11. fenway
    If you're using MYSQL5, stick with VARCHAR, not TEXT.
  12. fenway
    There are a variety of ways to store hierarchical dat.
  13. fenway
    In fact, you're not even using a password.
  14. fenway
    You can use CASE in your ORDER BY clause.
  15. fenway
    What do you have so far?
  16. fenway
    Why is your data stored this way anyway? And yes, you'll need to concat() those.
  17. fenway
    Huh?
  18. fenway
    You'll need GROUP_CONCAT() in MySQL.
  19. fenway

    RAM For mysql

    fenway replied to jaymc's topic in MySQL Help

    InnoDB has the potential to grow large with its namespaces, so it really depends how much data is there.
  20. fenway
    Huh?
  21. fenway
    How does the FS impact the DB?
  22. fenway
    Have you read the stickies on this board yet?
  23. fenway
    I don't understand how you want them ordered... please clarify.
  24. fenway
    You can also use SQL_CALC_FOUND_ROWS().....
  25. fenway
    Then I don't know how to help... sorry.
×
×
  • 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.