Mysql Update

Update table name - enter your table where you will update data

Set - enter Column Name you want to update. Then Column Valise String or Column Value Number.

Important - if you want update Column with string value - select Column Value String and then select Column Value Number with 0 integer. (case 1) If you want update with Number - select Column Value Number and leave empty Value String. (case 2)

Case 1

Case 2

WHERE statemant is the same as Set with the same rules. If you want condition Where with string value - select Column Value String and then select Column Value Number with 0 integer. If you want where condition with Number - select Column Value Number and leave empty Value String.

Example of full UPDATE instruction:

In other words it will update table users with age from age variable and name from name variable where id of the user is 1.

UPDATE users SET age = [age variable], name = [name variable] WHERE id = '1'