/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

7 votes138 views1 answer
Grant schema permissions postgres
SQL
3 votes128 views4 answers
Order by desc postgres
SQL
0 vote131 views1 answer
Mysql cli output to a file
SQL
1 vote121 views1 answer
Rows to comma separated values in mssql
SQL
1 vote133 views1 answer
Search for replace in mysql
SQL
0 vote133 views1 answer
Default value false mysql
SQL
9 votes170 views1 answer
No sql
SQL
0 vote127 views1 answer
Connexion mysql
SQL
0 vote137 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote135 views1 answer
How to display value of variable in mysql
SQL

Share