I propose the ability to delete a record with no P

[leegold]

When i try to delete a record mysqljog will not. It says its an illegal action because the table does not have a primary key field.

I propose the ability to delete a record with no PK.

[peterlaursen]

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 ….

[leegold]

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.

[peterlaursen]

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