Re: MYSQL Query Browser - Can't delete rows..
"Michael G. Zinner" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.mycc |
|---|---|
| Organization | MySQL AB |
| Message-ID | <[email protected]> |
Ralph, You have to explicitly press the [Edit] button in the result set's Action Bar (or you can press F2 to edit a cell instead). Then the result set becomes editable and you can delete rows and change data. Modified data is highlighted. Then, when you press [Apply Changes] the rows get updated. We introduced this behaviour to prevent unintentional changes to the data that usually happen when you do a lot of selects and work quickly with the QB. One note, the table you are editing has to have a Primary Key. Otherwise it is not possible for us to write the UPDATE / DELETE statements. This will change when we get client side cursors. But it is always a good idea to have a Primary Key (preferably a integer column). Mike Ralph Brickley wrote: > For some reason, I can not perform any deletes on my table. I can add > rows… when I use > > DELETE * FROM TableName > > > > I get no deletion. Also, I can’t right-click delete any rows either, > Delete Row(s) is grayed out. Anyone know what is up? > -- Michael Zinner, GUI Developer MySQL AB, www.mysql.com Office: +43 676 753 26 30 Are you MySQL certified? www.mysql.com/certification -- MySQL GUI Tools Mailing List For list archives: http://lists.mysql.com/gui-tools To unsubscribe: http://lists.mysql.com/[email protected]