> For the complete documentation index, see [llms.txt](https://bloxsql.metatable.dev/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://bloxsql.metatable.dev/101/update-data.md).

# 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.

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

## BLOXsql Example

```lua
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)
```