Jump to content

fenway

Staff Alumni
  • Posts

    16,168
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by fenway

  1. Queries against numerical columns are always faster.
  2. Yeah, never do this.
  3. InnoDB's an entirely different beast -- and if you're not used to working with it on at least 7 different levels, it's going to be very, very painful transition.
  4. A sample of few hundred records would have sufficed....
  5. Ok -- but repair from frm should work, too, AFAIK.
  6. There isn't a more efficient way -- but yes, INNER JOIN wherever possible.
  7. This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=310040.0
  8. That's only becuase you're using INNER JOIN, not LEFT JOIN -- has nothing to do with the function.
  9. I think you're asking two separate things. 1) use last_insert_id() to get back the ID so that you can use it in subsequent statements. 2) Use FK constraints if you're serious.
  10. So, solved?
  11. You can't delete the data AND not delete the data. Flag's aren't a problem.
  12. Other post? Topic locked -- and don't double-post next time; that's a violation of the ToS.
  13. MySQL evolved for simple web applications years ago -- and personally, I still think it's best suited for exactly that.
  14. In general, as long as the math isn't used to search the database, you're ok.
  15. Sorry, I know it's been a while -- can you post the create table statements and some insert statements so that I can re-create this scenario on my end?
  16. Actually, I meant just rebuild the index file from the existing data -- though if you have a recent enough backup, your method works too.
  17. The JOIN and comma operators changed precedence across mysql versions a while back -- that alone makes it evil.
  18. Sounds like just the MYI file is an issue -- which is just the index data -- you should be able to rebuilt it without any data loss.
  19. That's nota mysql error.
  20. Then you need a sortorder column.
  21. It just leads to all kinds of problems -- missing join conditions, precedence hell will left joins, the list is endless.
  22. My comment was extremely helpful -- I kept you from violating your database's referential integrity. Just a simple counter should do it -- if you need help with that, I'll move this to the php forum.
  23. Further to the last post, NEVER use implicit notation -- it's just evil.
  24. You don't want this at all. If you want to number your records, do so in PHP -- leave the DB records alone.
  25. It's really annoying that the update_time isn't maintained on windows. So really, they're just using the same code on both platforms, instead of doing it properly. Seems like an easy patch to commit.
×
×
  • 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.