Using WinMySQL Professional

Delete a record

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>Delete» submenu allows a user to add a record in the current table. Obviously, he must have the «Can DELETE» privilege granted.

How to delete a record ?

To delete a record, first, be sure that the grid is switched in table editor mode, put the cursor on a record field which must be deleted, then invoke the «Record>Insert» submenu clicking on it or use the «Ctrl-Del» which is really more ergonomic.

Note : Because of the RowID mechanism not yet supported by MySQL®, if the table doesn't have any primary key, it is possible that several identical lines may be affected. If the table is in this case, WinMySQL Professional will notity if the «Record>No primary key warning» submenu is unchecked.