Delete Data

Delete Data From a MySQL Table

DELETE is used to delete records from a MySQL table.

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

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)