Re: QueryBrowser 1.1.1 - edit fields
Adam Majer <[email protected]>
| Newsgroups | gmane.comp.db.mysql.mycc |
|---|---|
| Organization | Galactica Software Corporation |
| Message-ID | <[email protected]> |
Raphael Matthias Krug wrote: >Hi Mike, > >thanks for that. > >Now it seems to work. But untill a few weeks ago it worked without >this key. Did you change anything in this direction? I checked all my >databases and none of them had a primary key, they had all an >index, but not more. > > Without a primary key it is not possible to determine that a given row is unique. For example, Data1 | --------+ 1 1 2 1 Then you want to update the second row. That is not possible since UPDATE table SET Data1="3" WHERE Data1="1" will update all three rows. Data without primary key can only be appended (inserted) and not deleted or modified in a unique manner. Therefore, if query browser allowed for data to be edited without a primary key, then it was a bug in the query browser. - Adam -- Building your applications one byte at a time http://www.galacticasoftware.com -- MySQL GUI Tools Mailing List For list archives: http://lists.mysql.com/gui-tools To unsubscribe: http://lists.mysql.com/[email protected]