Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    15

    Answered: Problem to do update

    Hi,
    what is the reason to the following problem

    17:07:56 update t2 set system='VG' where system='OK' Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 0.000 sec

    got, using MySql?

  2. Best Answer
    Posted by Pat Phelan

    "You need to turn the safe update mode off.
    Code:
    SET SQL_SAFE_UPDATES=0;
    
    UPDATE t2
       SET system = 'VG'
       WHERE  system = 'OK';
    -PatP"


  3. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You need to turn the safe update mode off.
    Code:
    SET SQL_SAFE_UPDATES=0;
    
    UPDATE t2
       SET system = 'VG'
       WHERE  system = 'OK';
    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #3
    Join Date
    Jan 2010
    Posts
    15

    Re: Problem to do update

    Thanks to your help.
    Last edited by HuaMin; 06-04-15 at 23:52.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •