(QUERY) UPDATE data into MYSQL using SQL connector

Hihi..

How to write the update query by using Arduino code in order to update (overwrite) the previous data in MYSQL.

Below is the example for FIXED VALUE QUERY. Its work well but how to change to variable value ?

char UPDATE_SQL[] = "update [database] set [column_name] = [new_fixed_value] where [column_name] = [previous value] ;

What have you tried? Post your code and maybe someone can help.

You can use snprintf() to construct the query, using any variables in the process that you like. You do not have to hardcode the query.