Mysql for Game Creator 2
  • Welcome!
  • Requirements and info
  • First steps
  • instructions
    • Mysql Select
    • Mysql Query
    • Mysql Insert
    • Mysql Update
    • Mysql Delete
    • Mysql Clear Table
    • Mysql close connection
    • Other
      • Encrypt String
      • Decrypt String
      • Text to Variable
      • Generate Random String
    • Question/answer
Powered by GitBook
On this page
  1. instructions

Mysql Update

PreviousMysql InsertNextMysql Delete

Last updated 3 years ago

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'