Unsupported Screen Size: The viewport size is too small for the theme to render properly.

I propose the ability to delete a record with no P

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › I propose the ability to delete a record with no P

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 3, 2005 at 1:11 am #16925
      peterlaursen
      Participant

      As I have said a couple of times I belive that an UNIQUE INDEX or a PRIMARY KEY should be used for identifikation of records in case of deletions and syncronizarion. Yog right now only supports a PK.

      But there MUST be either UNIQUE INDEX or a PRIMARY KEY. If none of those are present, you can't be sure that there are not identical records ….

    • February 3, 2005 at 3:06 pm #16926
      leegold
      Member
      peterlaursen wrote on Feb 3 2005, 01:11 AM:
      “But there MUST be either UNIQUE INDEX or a PRIMARY KEY.   If none of those are present, you can't be sure that there are not identical records ….”

      It's a GUI, therefore I should be able to visually inspect the record and do what I want. IMHO.

    • February 3, 2005 at 3:41 pm #16927
      peterlaursen
      Participant

      Yes, but still it's a database CLIENT. It's not a progrram with an integrated DB and GUI. There is only the methods available for working on the BD as supplied by the DB vendor (mysql). For the dicussion it does not matter whether you connect with the C-api as sqlyog does or any other method. Sqlyog is not part of the database.

      I find it harzardeous to DELETE or UPDATE a record if it is not uniquely identified. For databases used by personal websites and the like you might be able to control it, but with big corporate databases – no!

      But I agree that other ways of uniquely identifying a record than the PK (and I can only think of an unique index) should be possible.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.