---
name: "DB.exec"
section: "3kaya"
platform: "linux"
package: "kaya"
version: "0.4.4-6.2"
release: "Debian 8 (Jessie)"
platforms: ["linux"]
url: "https://new.carta.tech/DB.exec"
---

# DB.exec(3kaya)

Execute a query

## NAME

DB::exec - Execute a query

## SYNOPSIS

**DBResult exec(** *DBHandle\<a\>  con, String query* **)**

## DESCRIPTION

Execute a query with the given connection handle.

-

   res = exec(conn,"SELECT id,name FROM People");\
    if (res.rows \> 0) {\
        for row in res.table {\
            // row\[0\] = DBInt(id)\
            // row\[1\] = DBText(name)\
        }\
    }

Non-SELECT queries will generally not return any result rows.

## AUTHORS

Kaya standard library by Edwin Brady, Chris Morris and others (kaya@kayalang.org). For further information see http://kayalang.org/

## LICENSE

The Kaya standard library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License (version 2.1 or any later version) as published by the Free Software Foundation.

## RELATED

**DB.DBHandle (3kaya)**

**DB.DBResult (3kaya)**

**DB.DBValue (3kaya)**

**DB.incExec (3kaya)**