15 August 2018

There are actually two ways of updating in MySQL. This example uses the simpler way. Other way is to define columns and corresponding values sepparately.

Source code viewer
  1. UPDATE my_table SET my_column_1 = 'my_value_1', my_column_2 = 'my_value_2' where unique_id = 1;
Programming Language: MySQL