/SQL/Sql run multiple updates in one query

Sql run multiple updates in one query

Sql run multiple updates in one query

UPDATE table_name
SET   field_name = 
      case  field_name2 
      when 'value' then 'change_to'
      when 'value2' then 'change_to2'
end

1

Source: stackoverflow.com

Similar codes

2 votes103 views1 answer
Rails execute sql
SQL
0 vote113 views1 answer
Reset keys in sql
SQL
0 vote100 views1 answer
Postgre admin slow
SQL
0 vote114 views1 answer
Count characters of string mysql
SQL
13 votes96 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote94 views1 answer
Start stop mysql linux
SQL
-1 vote102 views1 answer
Condition in orderby mysql
SQL
3 votes90 views1 answer
Sql timestamp to date
SQL
0 vote104 views1 answer
Sqlite3 get data from table c
SQL
0 vote95 views1 answer
T-sql email validation
SQL

Share