Jump to content

fenway

Staff Alumni
  • Posts

    16,168
  • Joined

  • Last visited

  • Days Won

    4

fenway last won the day on April 3 2019

fenway had the most liked content!

About fenway

  • Birthday 07/08/1979

Profile Information

  • Gender
    Male
  • Location
    Toronto, ON

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

fenway's Achievements

Advanced Member

Advanced Member (4/5)

21

Reputation

  1. You can do magic with SUBSTRING_INDEX and POSITION, but I'm not sure you want to.
  2. You can use REGEXP -- but it won't be very efficient.
  3. Duplicate should be referring to individual field values, not parts of a field -- storing delimited data that you need to consider separately is likely going to bite you soon enough, if it hasn't already. There's all sorts of tomfoolery you can do with FIND_IN_SET(), but I don't recommend it.
  4. Very difficult to tell what you're fererring to -- but I'm assuming that your PHP code isn't actually *making* a table -- DML vs DDL matters.
  5. Welcome back... it's been a while, but I'm still here ;-)
  6. Assuming it truly goes into the "same dropdown", you might get away with some version of UNION.
  7. I'm not certain LAST_INSERT_ID() is meaningful after that last SELECT -- why do you need to get the values you just inserted? Why not do with inside a function?
  8. Are you getting that error in the replication thread?
  9. Start by posting the actual code for the SP.
  10. Well, this is the problem -- the DBs need to begin in an identical state in order to begin replication.
  11. How did you set up the slave DB to beginwith?
  12. fenway

    ID to GUID

    Why do you want to do this?
  13. Here's to more active gurus!
×
×
  • 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.