Re: QueryBrowser 1.1.1 - edit fields

Hi Adam,

one stupid question. What difference does it make in your example, if 
this one columne has a primary key?

I my opinion it would make sense to update all fields, which contain 1. 
But I am only a user, not a programmer :-)

Raphael

> 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]