Sqlyog Wants To Update The Whole Table With Current Row Info.

[sathish]

Hello,

If your table that does not have a primary key then SQLyog uses data from ALL columns of the edited row to construct the WHERE clause. This is done to minimize the chances of duplicate updates.

Please read this FAQ:

http://webyog.com/faq/28_70_en.html

You can turn ON this warning setting by checking Tools->Preferences->Others->Prompt if multiple rows are getting updated.

Regards,

Sathish

[Interspace]

'sathish' wrote:

Hello,

If your table that does not have a primary key then SQLyog uses data from ALL columns of the edited row to construct the WHERE clause. This is done to minimize the chances of duplicate updates.

Please read this FAQ:

http://webyog.com/faq/28_70_en.html

You can turn ON this warning setting by checking Tools->Preferences->Others->Prompt if multiple rows are getting updated.

Regards,

Sathish

Ah , that seems to been the problem , so i edited one of the columns to be the primary key and it seem to work a lot better. Weird it worked for so loing until it started giving me problems , cheers.

[Author]

Posts