Skip to main content

Forums

This topic contains 2 replies, has 3 voices, and was last updated by  __ 4 years, 1 month ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #203099

    bearhead
    Participant

    This is probably a rather unique situation, but hopefully someone has come across a similar situation before.

    I have a mysql table that is populated with records dependent on data from another program (deltek vision). Every so often, the data from this other program is updated, and subsequently the mysql table is automatically updated as well.

    If I were to manually add a record to the mysql table, would that record get wiped out when deltek vision runs its update?

    Unfortunately I can’t test this myself, because I don’t have admin access to deltek vision. The person who does is on vacation for the next week. ><

    #203102

    shaneisme
    Participant

    This reply has been reported for inappropriate content.

    No, if you add a new record it will advance the key count and the next record will be added after. I’m making a pure assumption considering we don’t know your schema or code, but if it’s set up properly that should take place.

    #203156

    __
    Participant

    This reply has been reported for inappropriate content.

    My off-the-cuff reaction would also be “no,” but if their code does something weird… : )

    I have seen people who “update” their DB by truncating it and re-inserting everything.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

icon-link icon-logo-star icon-search icon-star