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)
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'
Last updated