Using WinMySQL Professional

No primary key warning

Only accessible when connected and a table is active and when the grid is switched to table editor mode (to be sure, perform a «Table management>Reload» with «Ctrl-Z»), the «Record>No primary key warning» submenu says to WinMySQL Professional if the users wish a warning each time they delete (see the «Submenu Record>Delete» section), update (see the «Submenu Record>Insert» section) a record on a table without primary key.

Indeed, because of the RowID mechanism not yet supported by MySQL®, if the current table doesn't have any primary key, it is possible that several identical lines may be affected by an update or a delete operation on a record.

To toggle this submenu, just click on it. The default is checked : WinMySQL Professional notifies when you delete or update a record on a current table which doesn't have any primary key.