# Delete Data

## Delete Data From a MySQL Table

DELETE is used to delete records from a MySQL table.&#x20;

```sql
DELETE FROM table_name WHERE some_column = some_value
```

Make sure you include the clause WHERE so you specify the exact thing you want to delete. If you remove the WHERE clause, you will delete all records on that table.

## 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("DELETE FROM players WHERE userid=1", Settings)
```
