reset password
Author Message
hpatel13
Posts: 6
Posted 18:08 Feb 26, 2013 |

Professor Sun,

I got an error while executing a Update query on MySQL Workbench

 




	update employees set first_name = 'Tom', last_name = 'Smith' where first_name = 'John' and last_name = 'Doe';



	 



	Error: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 Queries and reconnect.



	 



	Its not updating....



    
    
  




    
cysun

    
Posts: 2935

  		

          
    

      Posted 19:24 Feb 26, 2013 |
      
    

    
    
Read the error message.