Update Data

UPDATE Data with MySQL

UPDATE Is used a lot, for example, if you have an economy in your amazing ROBLOX game, you need to update your player's currency.

UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value 

BLOXsql Example

local BLOXsql = require(16229654720) 
local Settings= {
	-- Ensure you whitelist "141.98.74.17" with your database host.
	Username = "rampage_admin",
	Password = "1234567890",
	Host = "localhost",
	Database = "rampage_main"
}

BLOXsql:execute("UPDATE players SET money=500 WHERE userid=1", Settings)

Last updated

Was this helpful?