Skip to Content
Cobalt

cobalt_mysql

The MariaDB layer, which also answers as oxmysql, mysql-async and ghmattimysql, so exports.oxmysql, exports.ghmattimysql, exports['mysql-async'] and the @oxmysql/lib/MySQL.lua include (MySQL.Async, MySQL.Sync, MySQL.ready) all reach it.

ExportSideWhat it does
callServerRuns one operation for @oxmysql/lib/MySQL.lua and returns { value } or { nil, error }, inline when the answer arrives within mysql_inline_budget_ms.
endTransactionServerCommits or rolls back a startTransaction session and returns whether it committed.
queryServeroxmysql's callback form, kept for scripts that call exports.oxmysql directly.
singleServerAs query, returning the first row.
scalarServerAs query, returning the first column of the first row.
insertServerAs query, returning the insert id.
updateServerAs query, returning the affected row count.
prepareServerRuns a prepared statement once per parameter set.
rawExecuteServerAs prepare, returning mysql2's raw results.
transactionServerRuns every statement in one transaction and passes whether it committed.
startTransactionServerRuns fn on one connection inside a transaction; it commits unless fn returns false or errors.
isReadyServerWhether the pool has connected.
awaitConnectionServerWaits until the pool has connected.
storeServerPasses query back unchanged, for mysql-async's store.
executeServerAs query; oxmysql's older name.
fetchServerAs query; oxmysql's older name.
query_asyncServerAs query, returning the result to an awaiting caller and raising on error.
querySyncServerAs query, returning the result to an awaiting caller and raising on error.
single_asyncServerAs single, returning the result to an awaiting caller and raising on error.
singleSyncServerAs single, returning the result to an awaiting caller and raising on error.
scalar_asyncServerAs scalar, returning the result to an awaiting caller and raising on error.
scalarSyncServerAs scalar, returning the result to an awaiting caller and raising on error.
insert_asyncServerAs insert, returning the result to an awaiting caller and raising on error.
insertSyncServerAs insert, returning the result to an awaiting caller and raising on error.
update_asyncServerAs update, returning the result to an awaiting caller and raising on error.
updateSyncServerAs update, returning the result to an awaiting caller and raising on error.
prepare_asyncServerAs prepare, returning the result to an awaiting caller and raising on error.
prepareSyncServerAs prepare, returning the result to an awaiting caller and raising on error.
rawExecute_asyncServerAs rawExecute, returning the result to an awaiting caller and raising on error.
rawExecuteSyncServerAs rawExecute, returning the result to an awaiting caller and raising on error.
transaction_asyncServerAs transaction, returning the result to an awaiting caller and raising on error.
transactionSyncServerAs transaction, returning the result to an awaiting caller and raising on error.
execute_asyncServerAs query_async; execute is oxmysql's older name for query.
executeSyncServerAs querySync; execute is oxmysql's older name for query.
fetch_asyncServerAs query_async; fetch is oxmysql's older name for query.
fetchSyncServerAs querySync; fetch is oxmysql's older name for query.
isReady_asyncServerAs isReady, returned to an awaiting caller.
isReadySyncServerAs isReady, returned to an awaiting caller.
awaitConnection_asyncServerAs awaitConnection, returned to an awaiting caller.
awaitConnectionSyncServerAs awaitConnection, returned to an awaiting caller.
startTransaction_asyncServerAs startTransaction, returned to an awaiting caller.
store_asyncServerAs store, returned to an awaiting caller.
startTransactionSyncServerAs startTransaction, returned to an awaiting caller.
storeSyncServerAs store, returned to an awaiting caller.
executeServerAs cobalt_mysql's query.
executeSyncServerAs cobalt_mysql's query_async.
scalarServerAs cobalt_mysql's scalar.
scalarSyncServerAs cobalt_mysql's scalar_async.
transactionServerAs cobalt_mysql's transaction.
transactionSyncServerAs cobalt_mysql's transaction_async.
storeServerAs cobalt_mysql's store.
storeSyncServerAs cobalt_mysql's store_async.
is_readyServerAs cobalt_mysql's isReady: whether the database connection is up.
mysql_executeServerAs cobalt_mysql's update.
mysql_insertServerAs cobalt_mysql's insert.
mysql_fetch_allServerAs cobalt_mysql's query.
mysql_fetch_scalarServerAs cobalt_mysql's scalar.
mysql_transactionServerAs cobalt_mysql's transaction.
mysql_storeServerAs cobalt_mysql's store.

cobalt_mysql and oxmysql

call

Server

Runs one operation for @oxmysql/lib/MySQL.lua and returns { value } or { nil, error }, inline when the answer arrives within mysql_inline_budget_ms.

exports.cobalt_mysql:call(op, query, parameters, resource, isPromise, session, deferred)
ParameterTypeOptionalDescription
opintegerNo0 query, 1 single, 2 scalar, 3 insert, 4 update, 5 prepare, 6 rawExecute, 7 transaction, 8 begin, 9 query inside a transaction
querystring | table | nilNo
parameterstable | nilNo
resourcestringNothe calling resource, used in logs
isPromisebooleanNotrue when the caller raises or returns the error instead of having it printed
sessionintegerNostartTransaction session id, or 0
deferredbooleanYesskip the inline wait
ReturnsDescription
tablereply
Example
local reply = exports.cobalt_mysql:call(
    1,
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    GetCurrentResourceName(),
    true,
    1,
    true
)

endTransaction

Server

Commits or rolls back a startTransaction session and returns whether it committed.

exports.cobalt_mysql:endTransaction(session, commit, resource, scriptError)
ParameterTypeOptionalDescription
sessionintegerNo
commitbooleanNo
resourcestringNo
scriptErrorstringYesthe error that ended the transaction function
ReturnsDescription
booleancommitted
Example
local committed = exports.cobalt_mysql:endTransaction(
    1,
    true,
    GetCurrentResourceName(),
    'scriptError'
)

query

Server

oxmysql's callback form, kept for scripts that call exports.oxmysql directly.

exports.cobalt_mysql:query(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports.cobalt_mysql:query(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(result, err) end
)

single

Server

As query, returning the first row.

exports.cobalt_mysql:single(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports.cobalt_mysql:single(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(row, err) end
)

scalar

Server

As query, returning the first column of the first row.

exports.cobalt_mysql:scalar(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports.cobalt_mysql:scalar(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(value, err) end
)

insert

Server

As query, returning the insert id.

exports.cobalt_mysql:insert(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports.cobalt_mysql:insert(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(insertId, err) end
)

update

Server

As query, returning the affected row count.

exports.cobalt_mysql:update(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports.cobalt_mysql:update(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(affectedRows, err) end
)

prepare

Server

Runs a prepared statement once per parameter set.

exports.cobalt_mysql:prepare(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports.cobalt_mysql:prepare(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(result, err) end
)

rawExecute

Server

As prepare, returning mysql2's raw results.

exports.cobalt_mysql:rawExecute(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports.cobalt_mysql:rawExecute(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(result, err) end
)

transaction

Server

Runs every statement in one transaction and passes whether it committed.

exports.cobalt_mysql:transaction(queries, parameters, cb)
ParameterTypeOptionalDescription
queriestableNo
parameterstableYes
cbfunctionYes
Example
exports.cobalt_mysql:transaction(
    { { query = 'UPDATE players SET cash = cash - ? WHERE citizenid = ?', values = { 100, 'ABC12345' } } },
    { 'ABC12345' },
    function(committed) end
)

startTransaction

Server

Runs fn on one connection inside a transaction; it commits unless fn returns false or errors.

exports.cobalt_mysql:startTransaction(fn)
ParameterTypeOptionalDescription
fnfunctionNo
ReturnsDescription
booleancommitted
Example
local committed = exports.cobalt_mysql:startTransaction(function(query) return true end)

isReady

Server

Whether the pool has connected.

exports.cobalt_mysql:isReady()
ReturnsDescription
boolean
Example
local ok = exports.cobalt_mysql:isReady()

awaitConnection

Server

Waits until the pool has connected.

exports.cobalt_mysql:awaitConnection()
ReturnsDescription
true
Example
local result = exports.cobalt_mysql:awaitConnection()

store

Server

Passes query back unchanged, for mysql-async's store.

exports.cobalt_mysql:store(query, cb)
ParameterTypeOptionalDescription
querystringNo
cbfunctionNo
Example
exports.cobalt_mysql:store('SELECT * FROM players WHERE citizenid = ?', function(query) end)

execute

Server

As query; oxmysql's older name.

exports.cobalt_mysql:execute(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports.cobalt_mysql:execute(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(result, err) end
)

fetch

Server

As query; oxmysql's older name.

exports.cobalt_mysql:fetch(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports.cobalt_mysql:fetch(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(result, err) end
)

query_async

Server

As query, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:query_async(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:query_async(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

querySync

Server

As query, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:querySync(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:querySync(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

single_async

Server

As single, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:single_async(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
table?
Example
local result = exports.cobalt_mysql:single_async(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

singleSync

Server

As single, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:singleSync(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
table?
Example
local result = exports.cobalt_mysql:singleSync(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

scalar_async

Server

As scalar, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:scalar_async(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:scalar_async(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

scalarSync

Server

As scalar, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:scalarSync(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:scalarSync(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

insert_async

Server

As insert, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:insert_async(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
integer?
Example
local value = exports.cobalt_mysql:insert_async(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

insertSync

Server

As insert, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:insertSync(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
integer?
Example
local value = exports.cobalt_mysql:insertSync(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

update_async

Server

As update, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:update_async(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
integer?
Example
local value = exports.cobalt_mysql:update_async(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

updateSync

Server

As update, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:updateSync(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
integer?
Example
local value = exports.cobalt_mysql:updateSync(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

prepare_async

Server

As prepare, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:prepare_async(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:prepare_async(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

prepareSync

Server

As prepare, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:prepareSync(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:prepareSync(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

rawExecute_async

Server

As rawExecute, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:rawExecute_async(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:rawExecute_async(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

rawExecuteSync

Server

As rawExecute, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:rawExecuteSync(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:rawExecuteSync(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

transaction_async

Server

As transaction, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:transaction_async(queries, parameters)
ParameterTypeOptionalDescription
queriestableNo
parameterstableYes
ReturnsDescription
boolean
Example
local ok = exports.cobalt_mysql:transaction_async(
    { { query = 'UPDATE players SET cash = cash - ? WHERE citizenid = ?', values = { 100, 'ABC12345' } } },
    { 'ABC12345' }
)

transactionSync

Server

As transaction, returning the result to an awaiting caller and raising on error.

exports.cobalt_mysql:transactionSync(queries, parameters)
ParameterTypeOptionalDescription
queriestableNo
parameterstableYes
ReturnsDescription
boolean
Example
local ok = exports.cobalt_mysql:transactionSync(
    { { query = 'UPDATE players SET cash = cash - ? WHERE citizenid = ?', values = { 100, 'ABC12345' } } },
    { 'ABC12345' }
)

execute_async

Server

As query_async; execute is oxmysql's older name for query.

exports.cobalt_mysql:execute_async(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:execute_async(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

executeSync

Server

As querySync; execute is oxmysql's older name for query.

exports.cobalt_mysql:executeSync(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:executeSync(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

fetch_async

Server

As query_async; fetch is oxmysql's older name for query.

exports.cobalt_mysql:fetch_async(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:fetch_async(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

fetchSync

Server

As querySync; fetch is oxmysql's older name for query.

exports.cobalt_mysql:fetchSync(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.cobalt_mysql:fetchSync(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

isReady_async

Server

As isReady, returned to an awaiting caller.

exports.cobalt_mysql:isReady_async()
ReturnsDescription
boolean
Example
local ok = exports.cobalt_mysql:isReady_async()

isReadySync

Server

As isReady, returned to an awaiting caller.

exports.cobalt_mysql:isReadySync()
ReturnsDescription
boolean
Example
local ok = exports.cobalt_mysql:isReadySync()

awaitConnection_async

Server

As awaitConnection, returned to an awaiting caller.

exports.cobalt_mysql:awaitConnection_async()
ReturnsDescription
true
Example
local result = exports.cobalt_mysql:awaitConnection_async()

awaitConnectionSync

Server

As awaitConnection, returned to an awaiting caller.

exports.cobalt_mysql:awaitConnectionSync()
ReturnsDescription
true
Example
local result = exports.cobalt_mysql:awaitConnectionSync()

startTransaction_async

Server

As startTransaction, returned to an awaiting caller.

exports.cobalt_mysql:startTransaction_async(fn)
ParameterTypeOptionalDescription
fnfunctionNo
ReturnsDescription
booleancommitted
Example
local committed = exports.cobalt_mysql:startTransaction_async(function(query) return true end)

store_async

Server

As store, returned to an awaiting caller.

exports.cobalt_mysql:store_async(query, cb)
ParameterTypeOptionalDescription
querystringNo
cbfunctionNo
Example
exports.cobalt_mysql:store_async('SELECT * FROM players WHERE citizenid = ?', function(query) end)

startTransactionSync

Server

As startTransaction, returned to an awaiting caller.

exports.cobalt_mysql:startTransactionSync(fn)
ParameterTypeOptionalDescription
fnfunctionNo
ReturnsDescription
booleancommitted
Example
local committed = exports.cobalt_mysql:startTransactionSync(function(query) return true end)

storeSync

Server

As store, returned to an awaiting caller.

exports.cobalt_mysql:storeSync(query, cb)
ParameterTypeOptionalDescription
querystringNo
cbfunctionNo
Example
exports.cobalt_mysql:storeSync('SELECT * FROM players WHERE citizenid = ?', function(query) end)

ghmattimysql

execute

Server

As cobalt_mysql's query.

exports.ghmattimysql:execute(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports.ghmattimysql:execute(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(result, err) end
)

executeSync

Server

As cobalt_mysql's query_async.

exports.ghmattimysql:executeSync(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.ghmattimysql:executeSync(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

scalar

Server

As cobalt_mysql's scalar.

exports.ghmattimysql:scalar(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports.ghmattimysql:scalar(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(value, err) end
)

scalarSync

Server

As cobalt_mysql's scalar_async.

exports.ghmattimysql:scalarSync(query, parameters)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
ReturnsDescription
any
Example
local result = exports.ghmattimysql:scalarSync(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' }
)

transaction

Server

As cobalt_mysql's transaction.

exports.ghmattimysql:transaction(queries, parameters, cb)
ParameterTypeOptionalDescription
queriestableNo
parameterstableYes
cbfunctionYes
Example
exports.ghmattimysql:transaction(
    { { query = 'UPDATE players SET cash = cash - ? WHERE citizenid = ?', values = { 100, 'ABC12345' } } },
    { 'ABC12345' },
    function(committed) end
)

transactionSync

Server

As cobalt_mysql's transaction_async.

exports.ghmattimysql:transactionSync(queries, parameters)
ParameterTypeOptionalDescription
queriestableNo
parameterstableYes
ReturnsDescription
booleancommitted
Example
local committed = exports.ghmattimysql:transactionSync(
    { { query = 'UPDATE players SET cash = cash - ? WHERE citizenid = ?', values = { 100, 'ABC12345' } } },
    { 'ABC12345' }
)

store

Server

As cobalt_mysql's store.

exports.ghmattimysql:store(query, cb)
ParameterTypeOptionalDescription
querystringNo
cbfunctionNo
Example
exports.ghmattimysql:store('SELECT * FROM players WHERE citizenid = ?', function(query) end)

storeSync

Server

As cobalt_mysql's store_async.

exports.ghmattimysql:storeSync(query, cb)
ParameterTypeOptionalDescription
querystringNo
cbfunctionNo
Example
exports.ghmattimysql:storeSync('SELECT * FROM players WHERE citizenid = ?', function(query) end)

mysql-async

is_ready

Server

As cobalt_mysql's isReady: whether the database connection is up. mysql-async's MySQL.ready polls it.

exports['mysql-async']:is_ready()
ReturnsDescription
boolean
Example
local ok = exports['mysql-async']:is_ready()

mysql_execute

Server

As cobalt_mysql's update.

exports['mysql-async']:mysql_execute(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports['mysql-async']:mysql_execute(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(affectedRows, err) end
)

mysql_insert

Server

As cobalt_mysql's insert.

exports['mysql-async']:mysql_insert(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports['mysql-async']:mysql_insert(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(insertId, err) end
)

mysql_fetch_all

Server

As cobalt_mysql's query.

exports['mysql-async']:mysql_fetch_all(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports['mysql-async']:mysql_fetch_all(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(result, err) end
)

mysql_fetch_scalar

Server

As cobalt_mysql's scalar.

exports['mysql-async']:mysql_fetch_scalar(query, parameters, cb)
ParameterTypeOptionalDescription
querystringNo
parameterstableYes
cbfunctionYes
Example
exports['mysql-async']:mysql_fetch_scalar(
    'SELECT * FROM players WHERE citizenid = ?',
    { 'ABC12345' },
    function(value, err) end
)

mysql_transaction

Server

As cobalt_mysql's transaction.

exports['mysql-async']:mysql_transaction(queries, parameters, cb)
ParameterTypeOptionalDescription
queriestableNo
parameterstableYes
cbfunctionYes
Example
exports['mysql-async']:mysql_transaction(
    { { query = 'UPDATE players SET cash = cash - ? WHERE citizenid = ?', values = { 100, 'ABC12345' } } },
    { 'ABC12345' },
    function(committed) end
)

mysql_store

Server

As cobalt_mysql's store.

exports['mysql-async']:mysql_store(query, cb)
ParameterTypeOptionalDescription
querystringNo
cbfunctionNo
Example
exports['mysql-async']:mysql_store('SELECT * FROM players WHERE citizenid = ?', function(query) end)

On this page