I am using mySql on my work computer which is a compaq EVO with win2000 SP3 and 1 gig of ram. if any more details are needed I can provide them.

The problem happens with all combinations of mySql 3.23.55, and 4.09 and mySqlCC 0.8.8 and 0.8.9. After I create a table, if I have more than one row in that table when I update a single value in a single row, every row in that column gets the new value if a primary key has been specified for that table.

When no primary key has been specified I can update a single value without affecting other rows.

Any ideas?