Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 1 post (of 1 total)
  • Author
    Posts
  • in reply to: Sqlyog Wants To Update The Whole Table With Current Row Info. #32673
    Interspace
    Member
    '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.

Viewing 1 post (of 1 total)