Spreadsheet / Table Control Makes Silly Sql

[doconnor]

Version 5.21

See http://clockwerx.blogspot.com/2007/02/sqlyog-annoyances.html

1. Do a query like “SELECT a.id, a.name, a.* FROM a”

2. Swap from read only to edit mode

3. Go through and set the a.name to NULL

4. Move to the next row

Expected:

SQLyog does an update statement – UPDATE a SET name = NULL WHERE a.id = ?

SQLyog should only actually update the changed values (name).

Actual:

SQLyog does an update statement – UPDATE a SET id = ?, name = NULL, id=?, name=”fish” WHERE a.id = ?

Subsequently, the change you made (a.name set to null) is lost, because it's set to “fish” later on in the very same query)

[peterlaursen]

Ok now I understand!

When updating SQLyog updates every column in the grid. There is no logic in the grid to 'remember'

that a row is printed there twice.

With this query

SELECT a.id, a.name, a.* …

it happens as you describe it. Why do you need to “SELECT a.id, a.name” explicitly when you “SELECT a.*” ??

Do you know any graphical grid-type database client doing otherwise?

[Author]

Posts