Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
above error came in MySQL Workbench 5.2. During executing update command on table using MySQL Workbench 5.2. while updating rows.
update bl_user set user_email='smnjha989@gmail.com' where user_name='suman';
above error came in MySQL Workbench 5.2. During executing update command on table using MySQL Workbench 5.2. while updating rows.
update bl_user set user_email='smnjha989@gmail.com' where user_name='suman';
Solution
Off the below safe update option…
Update bl_user set
user_email='smnjha989@gmail.com' where user_name='suman';
12 row(s) affected Rows matched: 12 Changed: 12 Warnings: 0 0.031 sec
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757