/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

0 vote242 views1 answer
Mysql grouping functions
SQL
2 votes225 views1 answer
Date_format for time sql
SQL
1 vote238 views1 answer
Raw query must include primary key
SQL
10 votes229 views4 answers
Mysql one week ago
SQL
2 votes235 views1 answer
Creating a view SQL
SQL
0 vote249 views1 answer
Can we rollback in sql
SQL
0 vote251 views1 answer
Changing name of column and datatype in sql
SQL
0 vote238 views1 answer
Window function to forward fill
SQL
4 votes216 views2 answers
What is table in sql
SQL
0 vote282 views1 answer
Sql select without column name
SQL

Share