vertx / io.vertx.kotlin.ext.asyncsql / io.vertx.ext.asyncsql.MySQLClient / querySingleWithParamsAwait

# querySingleWithParamsAwait

`suspend fun MySQLClient.querySingleWithParamsAwait(sql: String, arguments: JsonArray): JsonArray?`

Execute a one shot SQL statement with arguments that returns a single SQL row. This method will reduce the boilerplate code by getting a connection from the pool (this object) and return it back after the execution. Only the first result from the result set is returned.

### Parameters

`sql` - the statement to execute

`arguments` - the arguments

`handler` - the result handler

Returnself