delete from internal.db

[botshara]

Hello, in trying to delete some records from  internal.db using sqlite db browser, but I got error.

SQL

DELETE FROM accounts, userdata

USING accounts

INNER JOIN userdata on (accounts.id = userdata.userid)

WHERE accounts.name='somename'

Error: Error: near ",": syntax error

What is wrong ?

Edited April 7, 2017 by botshara

[Pembo]

When using SQL in MTA you must use it within the MTA predefined functions:

 

dbConnect()		--establish the connection to database
dbExec()		--execute a database query with no result
dbQuery()		--database query with result

An example of dbExec:

addEventHandler("onResourceStart", resourceRoot,
  function()
    connection = dbConnect("sqlite", "database.db")
    dbExec(connection, "DELETE FROM tableName WHERE dataName = ?", dataName)
  end
)

 

Edited April 8, 2017 by Pembo